| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
