Hello,
Im trying to get a Oracle database to R, but I'm having problems with most
of SQL sintax. Suppose that Im trying to bring a table "TABLE" with
columns
"COL1","COL2",.. from schema "SCHEMA". What am I
doing wrong?
library(RODBC)
channel<-odbcConnect("xxx",uid="xxx",pwd="xxx")
sqlQuery(channel, "select * from SCHEMA.TABLE")
[it works fine]
sqlQuery(channel, "select * from SCHEMA.TABLE where COL1>10")
[returns
[""[RODBC] ERROR: Could not SQLExecDirect"
[" (...) :invalid table name"]
Oracle 9i
--
View this message in context:
http://www.nabble.com/Problems-With-RODBC%2C-sqlQuery-tp25806690p25806690.html
Sent from the R help mailing list archive at Nabble.com.
