[R] Using the ROracle package with Oracle 10 ?

[Ram Dessau]

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