Adobe have a hotfix for this which will be part of the next cumulative update for cf 8 (schedule unknown)
http://zacster.blogspot.com/2008/01/my-cf-oracle-problem-ora-00933-was.html On Nov 9, 2007 1:15 AM, Zac Spitzer <[EMAIL PROTECTED]> wrote: > neither the data direct or the oracle driver liked it, it threw > "ORA-00911: invalid character" > > worth a shot tho, thanks > > On Nov 9, 2007 12:37 AM, Simon Haddon <[EMAIL PROTECTED]> wrote: > > Being that this is the oracle direct driver you might want to try a ; on > the > > end. Just on the off chance. > > > > Cheers, > > Simon > > > > > > > > On 02/11/2007, Zac Spitzer <[EMAIL PROTECTED]> wrote: > > > > > > I just switched to using the oracle thin jdbc driver, over from using > > > the enterprise oracle driver with cf8 and now i'm getting a strange > > > error > > > > > > The 11g jdbc drivers are available for a java 1.6 version i discovered > > > > > > ORA-00933: SQL command not properly ended > > > > > > for queries which work in sql plus etc... > > > > > > can anyone try this against the oracle thin driver? > > > > > > doesn't even far enough get to say the table is missing, just throws > > > the parse error straight away...argghh > > > > > > <cfquery name="q" datasource="zac_ora_thin"> > > > INSERT INTO REGIONS_R (ENTITYID1) > > > SELECT ENTITYID1 > > > FROM REGION > > > </cfquery> > > > > > > wierd... > > > > > > z > > > > > > > > > -- > > > Zac Spitzer > > > http://zacster.blogspot.com/ > > > +61 405 847 168 (aussie moible) > > > > > > > > > > > > > > -- > > Cheers > > Simon Haddon > > > > > > > > > > > > > > -- > Zac Spitzer > http://zacster.blogspot.com/ > +61 405 847 168 (aussie moible) > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
