ORA-32766: instr with negative offset: use varchar semantics
on LOBs
- 1 Answers
- 2568 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Action: 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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-30153: An invalid File Object is passed to the OCIFile function
ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction
ORA-25123: Too many components specified in the name.
TNS-02515: Encryption/crypto-checksumming: unknown control type
PLS-01407: One of the identifiers CHAR, CHARACTER, or INTEGER has been redefined by the programmer
ORA-14131: enabled UNIQUE constraint exists on one of the tables
CLSR-00502: Error number encountered when subscribing an EVM event
ORA-30485: missing ORDER BY expression in the window specification
ORA-01949: ROLE keyword expected
ORA-36278: (XSCGMDLAGG07) workspace object is not a valid valueset.
ORA-30557: function based index could not be properly maintained
DRG-52204: error while registering index
Oracle Errors 
