Parsing an XML file and inserting into Oracle SYS.XMLTYPE

[Carlos Paez]

Hi,

I am getting an error: "ORA-01704: string literal too long" when trying:
<cfset XMLfile = "motpo_exp_xml-ZX00009999-20070626-172221.xml">

        <!--- Read XML file into string variable called xmlString --->
        <CFFILE ACTION="READ" FILE="#XMLfile#" VARIABLE="xmlString">

        <cfquery name="iXMLorder" datasource="sds_dev">
                INSERT INTO xmlorders_new
                VALUES('1', '#xmlString#')
        </cfquery>

I get this error when working with any XML file larger than 4k.
How am I supposed to use CFQUERY to insert the XML file as a string if Oracle 
can't handle a string larger than 4k?
Has anyone worked around this problem before?

Thanks,
Carlos 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289564
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4