insert into AUDIT_TABLE( "TIMESTAMP", AUDITCATEGORY, USERID, AUDIT_XML, "AUDITID", "SOURCE", "ROLE", EVENT_ID, EVENT_DATA, TYPE_OF_APPLICATION) select CURRENT_TIMESTAMP, AUDITCATEGORY, USERID, AUDIT_XML, (SELECT MAX(AUDITID)+1 FROM AUDIT_TABLE), dummyNumber||i, "ROLE", EVENT_ID, EVENT_DATA, TYPE_OF_APPLICATION from AUDIT_TABLE where "SOURCE"='1312171509321';
Hi, Above is a part of my stored procedure , I'm trying to create test data for AUDIT_TABLE by using a row in the existing table. I get an ORA-00932: inconsistent datatypes: expected - got BLOB error at the AUDI_XML line, which is a BLOB type. Why is there this error ?
Note : Select returns multiple rows and AUDIT_ID is the primary key for the table. Any help would be much appreciated.