Dear R-users,
I am working with a colleague on extracting and processing data from our
Oracle database using R scripts. We performed some initial testing using
functions available in the ROracle package. Overall, our tests were
successful and encouraging. There are however a couple of questions/problems
which I'd like to submit to your attentions:
1- the current version of ROracle appears to be pretty "old"
(published in
2007-10-15), although it seems functional with the recent version of Oracle
we are using to maintain our database. Is this package still maintained (and
updated) or has it been replaced by another one?
2- when running scripts including several queries (mostly data extraction
using dbSendQuery), only the ones following the opening of a new connection
(with dbConnect) were successful. This led us to conclude that only one
query could be send for each connection. Is this true or is there a way to
send multiple queries using a single connection?
Thank you in advance for your feedback
Sebastien
[[alternative HTML version deleted]]
