Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

selecting clob column and getting ORA-22275: invalid LOB locator specified

480574Jan 4 2006 — edited Jan 4 2006
I have a procedure where I am selecting a clob locator into a clob var and then trying to update the clob. I have tried copy and writeappend but I keep getting ORA-22275: invalid LOB locator specified. Anyone have any ideas?

Here's the code:
I'm passing in a clob variable as_email_body

lbl_clob clob;

SELECT email_body
INTO lbl_clob
FROM email_info
WHERE id = 1;

dbms_lob.WriteAppend ( lbl_clob, dbms_lob.GetLength(as_email_body), as_email_body);

When the writeappend failed I thought maybe I was using the wrong function so I tried copy
dbms_lob.Copy ( lbl_clob, as_email_body, dbms_lob.GetLength(as_email_body), dbms_lob.GetLength(lbl_clob)+ 1, 1);

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2006
Added on Jan 4 2006
3 comments
817 views