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!

ORA-24813: cannot send or receive an unsupported LOB

578292Feb 13 2009 — edited Feb 13 2009
Hi

I have the following code that errors out with the following error when i run it.

Error Message ORA-24813: cannot send or receive an unsupported LOB

My Code
declare

v_clob clob;

begin

   select DBMS_XMLQuery.GetXML('select * from dual') 
   into   v_clob
   from dual;
  dbms_output.put_line(v_clob);
Exception when others then 
   dbms_output.put_line(SQLERRM);
end;
does anyone what i'm missing.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2009
Added on Feb 13 2009
4 comments
3,675 views