Displaying 1 result from an estimated 1 matches for "tkf".
Did you mean:
tk
2003 Jul 09
2
RODBC and Oracle: error "table does not exist"
...Version 8.1.6.4.0:
> library(RODBC)
> channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE)
> # ok, this was succesful
> x <- sqlTables(channel)
> x[37, ]
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
37 <NA> TKF ABTGRNAMEN TABLE <NA>
> # ok, so the table I am looking for ("ABTGRNAMEN") is there, but:
> sqlFetch(channel, "ABTGRNAMEN")
[1] "[RODBC] ERROR: Could not SQLExecute"
[2] "S0002 942 [Oracle][ODBC][Ora]ORA-0094...