Unanswered: INSTR and SUBSTR on LONG column
MY_TABLE is defined as:
SUBSTR(MESSAGE, 18, 10)
I get the following error:
STATUS CHAR(1) NULL DEFAULT ('N')
MESSAGE LONG NULL
I've looked at dbms_lob and dbms_sql packages, but I don't think those will help. Is there a package or cast/convert that I can do to be able to test/parse the values in a LONG column.
ORA-00932: Inconsistent Data types.
And no, I am not happy with doing this. It's a structure handed to me (copied from a SQL database server) by people more familiar with Java than with databases.
Have you hugged your backup today?