Hex to string oracle conversion

Asked

Viewed 46 times

1

I created the following query and executing displays an error message. Someone has an idea of what might be?

Consultation:

SELECT UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW(relatorio)) FROM GRELBATCH 
where IDJOBLOG = (SELECT MAX(IDJOBLOG) FROM GRELBATCH);

Error message:

ORA-00997: invalid use of data type LONG

oracle

  • the report column is of type LONG RAW

  • 1

    The LONG type has some restrictions. See here. https://stackoverflow.com/questions/29116396/workaround-for-ora-00997-illegal-use-of-long-datatype

No answers

Browser other questions tagged oracle

You are not signed in. Login or sign up in order to post.