How to fix the Oracle error IMG-00718: the same Temporary LOB cannot be used as both source and destination?

In this post, you’ll learn more about the Oracle ErrorIMG-00718: the same Temporary LOB cannot be used as both source and destination with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMG-00718: the same Temporary LOB cannot be used as both source and destination

Reason for the Error IMG-00718: the same Temporary LOB cannot be used as both source and destination

Cause: A call was made to processCopy with the same Temporary LOB being specified as both the source and destination.

How to fix the Error IMG-00718: the same Temporary LOB cannot be used as both source and destination ?

You can fix this error in Oracle by following the below steps

Action: Specify a different LOB for parameter “dest”.