Displaying 2 results from an estimated 2 matches for "si_r".
Did you mean:
s_r
2004 Jul 14
3
ROracle - fetch gives empty dataframe
...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 established
> dbGetInfo(ora)
$drvName
[1] "Oracle (ProC/C++)"
$connectionIds
$connectionIds...
2004 Jul 14
0
ROracle - fetch gives...(corrected SQL code)
...thin 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
#### seems like connection has been established
> dbGetInfo(ora)
$drvName
[1] "Oracle (Pr...