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

NNO-00261: cannot construct configuration checkpoint file name

1 Answers  

---

DRG-11113: value of string must be one of string

1 Answers  

---

LSX-00168: referring form of "~S" must NOT occur at the top level

1 Answers  

---

NNL-00287: Cache flush occurs in string

1 Answers  

---

ORA-19618: cannot name files after restoreValidate has been called

1 Answers  

---

---

ORA-27207: syntax error in device PARMS - parentheses mismatch or missing

1 Answers  

---

NID-00304: Datafile string - reverted

1 Answers  

---

IMG-00852: image index free failed

1 Answers  

---

ORA-28582: a direct connection to this agent is not allowed

1 Answers  

---

DRG-12217: tags cannot be more than 64 bytes

1 Answers  

---

ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  

---

RMAN-08127: cataloged backuppiece

1 Answers  

---