Hi James,
I did try to use cf_sql_clob but I was getting this error:
Error casting an object of type to an incompatible type. This usually
indicates a programming error in Java, although it could also mean you have
tried to use a foreign object in a different way than it was designed.
so I was forced to use cf_sql_longvarchar
On 9/27/07, James Holmes <[EMAIL PROTECTED]> wrote:
>
> If your column is CLOB, use cf_sql_clob as your type (that's what it's
> for).
>
> On 9/27/07, Carlos Paez Jr <[EMAIL PROTECTED]> wrote:
> > 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>
>
>
> --
> mxAjax / CFAjax docs and other useful articles:
> http://www.bifrost.com.au/blog/
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289644
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
