Oracle Error ORA-24805: LOB type mismatch

Oracle Error Message

ORA-24805: LOB type mismatch

Reason for the Error

When copying or appending LOB locators, both source and desctination LOB locators should be of the same type.

Solution

Pass the same type of LOB locators for copying or appending.