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) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
