How to fix the Oracle error PCC-02447: Cannot specify destination offset in a LOB WRITE APPEND?

In this post, you’ll learn more about the Oracle ErrorPCC-02447: 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

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

Reason for the Error PCC-02447: 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 PCC-02447: 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.