Home » Developer & Programmer » JDeveloper, Java & XML » ORA-19011 when inserting via sqlplus
ORA-19011 when inserting via sqlplus [message #112840] Tue, 29 March 2005 11:19
bpeasey
Messages: 46
Registered: March 2005
Member
Hi,

I have a large insert statement that return a "ORA-19011: Character string buffer too small" when it try to run it.

The target column is a clob. Here's the statement with many of the columns removed for readablity sake.

INSERT INTO t_staging(temp_xml) (SELECT '<VEHICLES>' ||
XMLAGG(XMLELEMENT ("VEHICLE",
xmlattributes(
AB_RG,AB_RG_001,

<snipped>

VISUAL_ID,WHEEL_DRIVE,
XSTATUS))) || '</VEHICLES>' AS "ROW" from policy_vehicle
where policy_num = (select distinct policy_num from policy
where policy_number = 3 ))

How can I get past this error and get my data into the table?

Best Regards,
Brian P.
Previous Topic: JSP front end interface
Next Topic: Cannot insert international characters into CLOB field
Goto Forum:
  


Current Time: Thu Feb 22 19:10:33 CST 2024