Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

I'm not sure what driver we use. We have CF enterprise, running on Solaris... and we only have one choice in the CFadmin for Oracle. -Carlo On 9/27/07, James Holmes <[EMAIL PROTECTED]> wrote: > > Which driver are you using? The CF Enterprise DataDirect one or the > Oracle Thin driver? > > On 9/2

Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

Which driver are you using? The CF Enterprise DataDirect one or the Oracle Thin driver? On 9/27/07, Carlos Paez Jr <[EMAIL PROTECTED]> wrote: > 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 > indicat

RE: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

riginal Message- From: Carlos Paez Jr [mailto:[EMAIL PROTECTED] Sent: Thursday, September 27, 2007 11:40 AM To: CF-Talk Subject: Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE Hi James, I did try to use cf_sql_clob but I was getting this error: Error casting an object of type to an in

Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

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 fo

Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

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 cf

Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

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: INSERT INTO xmlorders VALUES('69', ) -Carlos On 9/26/07, James Holmes <[EMAIL PROTECTED]> wrote: >

Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

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

Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

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 ab

RE: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

In the old days, when dealing with long, practically-unlimited strings, I would create a table that would hold 4000-byte chunks of the original string. I would insert 4000 bytes into a record, then increment a related sequence number, until all bytes were inserted. When outputting, I would query

RE: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

Hi Carlos, What is the DataType of your column where you are inserting this XML string. Looks like you need to Change the DataType of your column. Oracle can support storage of upto 4000 bytes(4k) for the VARCHAR2 datatype. You could consider moving to LONG or CLOB datatype. Check the link belo