Hi All

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 .


Regards
Sushant