dbms_lob.write Failed with ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275


Error Description:
PLSQL Block with dbms_lob.write command is getting failed with following error. Command: dbms_lob.write (tempblob,length(tempname), 1,utl_raw.cast_to_raw (substr(tempname,1,length(tempname))));

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 1124
ORA-06512: at line 12
Solution Description:
The reason for this error is because you have used a blob column in the PLSQL block which is not initialized. Blob variable needs to be initialized before using the dbms_lob.write. EMPTY_BLOB and EMPTY_CLOB functions need to be used to initialize a LOB variable. These functions return an empty LOB locator. You can use an insert or update command to initialize a LOB column.
Syntax:
update BL_TEST set TR_PIC=empty_blob();
DATA PUMP Reference Guide ….

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...
 

dba topics. Copyright 2011-14 All Rights Reserved | Site Map | Contact | Disclaimer