looks like a cf8 issue, just tried this with a simple java jdbc test case and it works fine
On Nov 2, 10:15 am, "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 Spitzerhttp://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 -~----------~----~----~----~------~----~------~--~---
