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


PCB-00639: Cannot specify destination offset in a LOB WRITE
APPEND



PCB-00639: 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. "700 - 725, Dynamic SQL error conditions"

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-40271: no statistically significant features were found

1 Answers  


ORA-38750: FLASHBACK DATABASE may not be performed using a dispatcher.

1 Answers  


QSM-02078: mv log must have new values

1 Answers  


TNS-00116: Pump failed during initial bequeath

1 Answers  


SQL*Loader-00803: %s field type not supported by External Table

1 Answers  






DRG-10708: invalid class id string for preference string

1 Answers  


SQL*Loader-00527: OCI return status: no data

1 Answers  


SQL*Loader-00481: HIDDEN may not be used with non-scalar fields.

1 Answers  


RMAN-06742: platform name 'string' longer than number

1 Answers  


ORA-25131: cannot modify unique(string) - unique key not defined for table

1 Answers  


ORA-19830: error from target database: string

1 Answers  


NNL-01044: Errors reading data stream: number

1 Answers  






Categories