Wednesday, March 25, 2009

ORA-22275: invalid LOB locator specified

Always check out the original article at for latest comments, fixes and updates.

You may get ORA-22275 in the following situation:

l_clob clob;
l_clob := dbms_xmlgen.getxml('select * from user_tables');
insert into files(document) values(l_clob);

ORA-22275: invalid LOB locator specified
ORA-06512: at line 6

The problem here is in the premature call of procedure DBMS_LOB.FREETEMPORARY, although the error is raised in the subsequent line.
This particular instance of DBMS_XMLGEN.GETXML is returning a temporary LOB that must be freed after use, therefore DBMS_LOB.FREETEMPORARY must be called after moving the LOB object into its "final" position inside the table.
When you insert a temporary LOB into a table, it becomes persistent.
See also see entry for another occurrence of ORA-22275.

See message translations for ORA-22275 and search additional resources.

1 comment:

Anonymous said...

Seriously, you work with Oracle and you use terms like Junk to refer to PCs? I don't necessarily disagree with you on the latter, but you are throwing hefty rocks while yourself perched inside a fragile glass house.

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles