ORA-06502 ORA-06512 ORA-22275

ORA- Error:

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


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


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

 dbms_lob.createtemporary(l_clob, true);

No comments:

Post a Comment