Displaying 2 results from an estimated 2 matches for "only2admin".
2004 Jul 14
3
ROracle - fetch gives empty dataframe
....5-5.tar.gz #since we have 64bit Oracle9i instalation
PROBLEM: after executing simple statement, from within R, "fetch"
function gives me the empty dataframe:
### CONNECTION, and SQL QUERY EXECUTION
> ora <- dbDriver("Oracle")
> con <- dbConnect(ora, "rado/only2admin"
> dbListTables(con)
character(0)
> rs <- dbSendQuery(con, "desc * from si_r where id=498")
> d <- fetch(rs, n= -1)
> dim(d)
[1] 0 3
str(d)
data.frame': 0 obs. of 3 variables:
$ ID : int
$ DAY: chr
$ R : num
#### seems like connections has been establis...
2004 Jul 14
0
ROracle - fetch gives...(corrected SQL code)
...for posting the second time, I corrected the SQL code:
PROBLEM: after executing simple statement, from within R, "fetch"
function gives me the empty dataframe:
### CONNECTION, and SQL QUERY EXECUTION
> ora <- dbDriver("Oracle")
> con <- dbConnect(ora, "rado/only2admin"
> dbListTables(con)
character(0)
> rs <- dbSendQuery(con, "select * from si_r where id=498")
^^^^^^ CORRECTION
> d <- fetch(rs, n= -1)
> dim(d)
[1] 0 3
str(d)
data.frame': 0 obs. of 3 variables:
$ ID : int
$ DAY: chr
$ R : num...