On Wed, 2007-07-18 at 08:04 +0100, Prof Brian Ripley wrote: > On Tue, 17 Jul 2007, Marc Schwartz wrote: > > > Try the sqlQuery() syntax with a semi-colon at the end of it: > > > > sqlQuery(essai, "select * from S_TYP_COLLEGES;") > > > > Oracle requires the semi-colon at the end of the SQL statement. > > Over ODBC? I've never heard of that, and others have used RODBC to > Oracle successfully when it does not itself add semicolons. What sqlFetch > is running is (in a vanilla setup) "SELECT * FROM 'S_TYP_COLLEGES'", and > we've heard of a few cases where the quotes were a problem, hence my > suggestion. > > The error message is not a syntax error (which is what I would expect > from a missing terminator), but that the table/view is not found.
I stand corrected. I was going from memory pertaining to some prior errors that I had when setting up my unixODBC/RODBC connection on Fedora to our Oracle server. Adding the semi-colon to the query string seemed to have helped to resolve at least part of the issue, but perhaps it was merely a red-herring. I just tried it here from home over our VPN and the queries worked with and without the semi-colon. Thanks for pointing that out. Regards, Marc ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.