Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PCC-02447: Cannot specify destination offset in a LOB WRITE
APPEND



PCC-02447: Cannot specify destination offset in a LOB WRITE APPEND..

Answer / guest

Cause: A destination offset was specified in a LOB WRITE
APPEND statement. The destination offset is assumed to be
the end of the LOB so specifying an explicit destination
offset is erroneous.

Action: Remove the destination offset from the LOB WRITE
APPEND statement.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.

1 Answers  


ORA-01221: data file string is not the same file to a background process

1 Answers  


TNS-12618: TNS:versions are incompatible

1 Answers  


ORA-25103: NOPARALLEL option can only be used with ALTER INDEX REBUILD

1 Answers  


SQL*Loader-00520: lfimknam failed for file (string)

1 Answers  






ORA-02379: profile string already exists

1 Answers  


ORA-02737: osnpcl: cannot tell orapop to exit

1 Answers  


ORA-22346: Type has cyclical dependency. Should use CASCADE option

1 Answers  


RMAN-06460: Controlfile copy string cannot be backed up by proxy.

1 Answers  


ORA-23446: duplicate template site

1 Answers  


RMAN-08022: channel string: restoring archive log

1 Answers  


ORA-16134: invalid MANAGED recovery FINISH option

1 Answers  






Categories