Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32766: instr with negative offset: use varchar semantics
on LOBs
- 1 Answers
- 3227 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-38463: invalid XML Tag list
ORA-09959: IMON: deletion of a process failed.
ORA-29255: Cursor contains both bind and define arrays which is not permissible
PLS-00459: this feature is not allowed in REPEATABLE subprogram
ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option
RMAN-08516: controlfile copy filename=string recid=string stamp=string
NID-00371: Change database name of database string to string? (Y/[N]) =>
IMG-00824: fail queue pop failed
ORA-07613: $GETJPIW failed in retrieving the user's process label
ORA-23305: internal deferred RPC error: string
ORA-19777: ASM file string cannot be proxy backed up.
ORA-10587: Invalid count for ALLOW n CORRUPTION option
Oracle Errors 
