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