R help - Oct 2006 - Using the ROracle package with Oracle 10 ?

Hi,

The ROracle package works very well reasonable easy R-code, 
the documention for ROracle is very usefull.
Thank you for this contribution to R !
 
A tip for complex SQL: 
I did however find difficulties to handle complex sql statements in an Oracle
script
(something with handling of spaces and line feeds)
This problem was solved by instead creating  "views" in oracle to 
do the complex sql and then only using simple SQL statement in R 
e.g. "select * from viewname"

Window binary for ROracle 10 ?
Is there anyone who could help with a version of ROracle for windows
which is compatible with Oracle 10 or more general just uses the
"default-home"
The available (not officially released) version only supports Oracle 9

I work in a clinical microbiology laboratory.
We try to develop the Roracle functionality to retrieve current data 
from the laboratory information system to generate
graphics for epidemiologic surveillance and controlcharts for ELISA robots.


Greetings

Ram Dessau,
Naestved Denmark



Ram Dessau
Overl?ge
Klinisk Mikrobiologisk afdeling
Storstr?mmens sygehus, N?stved
Ringstedgade 61
4700 N?stved
tel. 5572 9000 tone 4148 el. 4141
fax. 5572 6024

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: Ram Dessau.vcf
Url:
https://stat.ethz.ch/pipermail/r-help/attachments/20061019/001ed615/attachment.pl

"Ram Dessau" <rde at cn.stam.dk> writes:

[...]
> Window binary for ROracle 10 ?
>
> Is there anyone who could help with a version of ROracle for windows
> which is compatible with Oracle 10 or more general just uses the
> "default-home" The available (not officially released) version
only
> supports Oracle 9
Any used oracle 9 driver should be able to connect to a 10g instance
and work reasonably well with it.

Did you try connecting to a 10g instance?

Do you have a specific problem or thing not working?

Do you have errors ora-600 or ora-03113?

Jens