All, problem fixed! Thanks for the help!
I changed my Oracle column to type CLOB instead of SYS.XMLTYPE
and changed my insert query to explicitly cast with cfqueryparam:
<cfquery name="iXMLorder" datasource="sds_dev">
INSERT INTO xmlorders
VALUES('69', <cfqueryparam value="#xmlString#"
cfsqltype="cf_sql_longvarchar">)
</cfquery>
-Carlos
On 9/26/07, James Holmes <[EMAIL PROTECTED]> wrote:
>
> All CLOBS need to inserted using cfqueryparam (which you should be
> using anyway).
>
> Your query inserts a literal string, which is limited to 4000 bytes,
> no matter that the column datatype.
>
> On 9/27/07, Carlos Paez Jr <[EMAIL PROTECTED]> wrote:
> > Thanks for the replies and ideas.
> > The datatype of my column is SYS.XMLTYPE which I understood to be a
> CLOB;
> > which is the source of my confusion. CLOBs should hold up to 4 gig of
> data.
> > I'm thinking that this error might not be referring to the datatype of
> my
> > column, but rather, that oracle is not able to handle the length of the
> > string I'm inserting as #XMLSTRING#
> >
> > Michael, I think your solution would work, but like you said, I think
> there
> > must be a better way to do it now-a-days.
>
>
> --
> mxAjax / CFAjax docs and other useful articles:
> http://www.bifrost.com.au/blog/
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289632
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
