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”

Tags :

Leave Your Comment