Displaying 3 results from an estimated 3 matches for "fetch_default_rec".
2004 Jul 14
3
ROracle - fetch gives empty dataframe
...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[[1]]
<OraConnection:(14939,0)>
$fetch_default_rec
[1] 500
$managerId
<OraDriver:(14939)>
$length
[1] 10
$num_con
[1] 1
$counter
[1] 1
$clientVersion
[1] "0.5-4"
Maybe it is something stupid (and I need just a hint), or may be it is
something major.
Thanks in advance,
Rado Bonk
--
Dr. Radoslav Bonk
European Commission -...
2003 Oct 24
2
Oracle fetch problems
Hi,
I use the ROracle interface in the R 64bit version.
When I fetch a large number of rows from the database I get alternating
250 rows of what I want to see and than 250 rows junk and so on.
It does not matter whether I use the fetch command or dbGetquery or
whatever. My fetch_default_rec = 500 and I can not change it by setting
it explicitly in Oracle().
Any idea what's the problem here?
Thanks, joerg
2004 Jul 14
0
ROracle - fetch gives...(corrected SQL code)
...(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 (ProC/C++)"
$connectionIds
$connectionIds[[1]]
<OraConnection:(14939,0)>
$fetch_default_rec
[1] 500
$managerId
<OraDriver:(14939)>
$length
[1] 10
$num_con
[1] 1
$counter
[1] 1
$clientVersion
[1] "0.5-4"
Maybe it is something stupid (and I need just a hint), or may be it is
something major.
Thanks in advance,
Rado Bonk
--
Dr. Radoslav Bonk
European Commission - D...