How to fix the Oracle error PCB-00639: Cannot specify destination offset in a LOB WRITE APPEND?
In this post, you’ll learn more about the Oracle ErrorPCB-00639: Cannot specify destination offset in a LOB WRITE APPEND with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PCB-00639: Cannot specify destination offset in a LOB WRITE APPEND
Reason for the Error PCB-00639: Cannot specify destination offset in a LOB WRITE APPEND
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.
How to fix the Error PCB-00639: Cannot specify destination offset in a LOB WRITE APPEND ?
You can fix this error in Oracle by following the below steps
Action: Remove the destination offset from the LOB WRITE APPEND statement. “700 – 725, Dynamic SQL error conditions”
Leave Your Comment