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/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:289640
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
