Oracle Database Error Code ORA-32766 Description :
instr with negative offset: use varchar semantics on LOBs
Error Cause:
The current varchar behavior is different. e.g. instr(abcd, cd, -2, 1) returns 3, whereas instr(to_clob(abcd), cd, -2, 1) returns 0, (i.e. no match), because the reverse search starts from offset -2, which points to c and moving backward, i.e. d is ignored. This is symmetric to instr(dcba,dc,2,1), which returns 0.
How to Solve :
ORACLE uses the same varchar semantics on LOBs (instr). Using the same example, instr(to_clob(abcd), cd, -2, 1) will return 3 as in the varchar case.
Search Oracle Error Codes and Descriptions:
Be The First To Comment
Similar Errors
Please Leave Your Comments Below