Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32766: instr with negative offset: use varchar semantics
on LOBs
- 1 Answers
- 3311 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-29524: wrong types of arguments in call to 'string'
ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>
ORA-16524: unsupported operation
RMAN-00555: target database connect string must be specified
ORA-22816: unsupported feature with RETURNING clause
ORA-22317: typecode number is not legal as a number type
ORA-02034: speed bind not permitted
ORA-01096: program version (string) incompatible with instance (string)
RMAN-08532: channel string: restoring block(s) from datafilecopy string
ORA-22315: type "string" does not contain a map or order function
ORA-25247: %s is not a recipient of specified message
PCC-00136: Invalid SQL_CURSOR declaration
Oracle Errors 
