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