ORA-06502 ORA-06512 ORA-22275

ORA- Error:


declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "SYS.DBMS_LOB", line 960
ORA-06512: at line 19

Cause:

l_clob variable used in dbms_lob.LoadCLOBFromFile is not initialized causing it to remain empty.

Solution:

Initialized l_clob as below in begin block to solve the error.

 dbms_lob.createtemporary(l_clob, true);