clob & object types
I have a type as xml_payload . database is 817
create type xml_payload(id number, data clob);
create table test(col xml_payload);
insert into test values(xml_payload(1,'buildingxmlapplications'));
gives the following error :
ERROR at line 1:
ORA-00932: inconsistent datatypes
How to overcome this .
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Click Here to Expand Forum to Full Width