Displaying 6 results from an estimated 6 matches for "oraconnect".
Did you mean:
oneconnect
2005 Aug 25
5
ROracle and select query empty
...rv <- dbDriver("Oracle")
> summary(drv, verbose=TRUE)
<OraDriver:(6721)>
Driver name: Oracle (ProC/C++)
Max connections: 10
Conn. processed: 8
Default records per fetch: 500
Oracle R/S client version: 0.5-4
RS-DBI version: 0.1-9
Open connections: 2
1 <OraConnection:(6721,0)>
2 <OraConnection:(6721,7)>
>
> conn <- dbConnect(drv, "mathieu/toto at MYDB")
> summary(conn, verbose=TRUE) <OraConnection:(6721,7)>
User: mathieu
Dbname: MYDB
Oracle Server version:
>
> rs <- dbSendQuery(conn, statement = p...
2005 Aug 25
0
Irregular Time Series: zoo & its: Pros & Cons
...iver:(6721)>
> > Driver name: Oracle (ProC/C++)
> > Max connections: 10
> > Conn. processed: 8
> > Default records per fetch: 500
> > Oracle R/S client version: 0.5-4
> > RS-DBI version: 0.1-9
> > Open connections: 2
> > 1 <OraConnection:(6721,0)>
> > 2 <OraConnection:(6721,7)>
> >
> >>
> >> conn <- dbConnect(drv, "mathieu/toto at MYDB") summary(conn,
> >> verbose=TRUE) <OraConnection:(6721,7)>
> >>
> > User: mathieu
> > Dbname: MYD...
2004 Jul 14
3
ROracle - fetch gives empty dataframe
...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[[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...
2004 Jul 14
0
ROracle - fetch gives...(corrected SQL code)
...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 (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....
2008 Dec 24
0
Write a data frame to Oracle Data Base
...;- Oracle()
>con <- dbConnect(drv , 'uid','pw','db')
>mm <- data.frame(CO2)
> dbWriteTable(con,'eve_tmp',mm)
Error in function (classes, fdef, mtable) :
unable to find an inherited method for function "dbPrepareStatement",
for signature "OraConnection", "character", "list"
[1] FALSE
And I tried the RODBC package, 'write' function is OK.
Is it the Oracle version' problem? : (
Best regards
2009 Feb 09
0
ROracle - ORA-02005: implicit (-1) length not valid for this bind or define datatype
...;format" in "ROracle"
Creating a new generic function for "print" in "ROracle"
** help
>>> Building/Updating help pages for package 'ROracle'
Formats: text html latex example
DBIPreparedStatement-class text html latex example
OraConnection-class text html latex example
OraDriver-class text html latex example
OraObject-class text html latex example
OraPreparedStatement-class text html latex example
OraResult-class text...