Append a varchar to a LOB
459560Mar 13 2007 — edited Apr 30 2007I am trying to select a clob field appended to a varchar field, like this:
select a.notes || b.full_name
from notes_table a, contacts_table b
where....
The notes field is a CLOB and full_name is VARCHAR2. When I run this select I get the following error:
ORA-24813: cannot send or receive an unsupported LOB
Is there any way to do this?
Thanks,
Leslie