I managed to resolve my problem, I updated my ORACLE 8.1.7 driver to replace
the one that came with the oracle install and it now works a treat.
Gavin
Gavin Kennedy wrote:
> I am having the following problem with RODBC
>
> I connect to an oracle 8i (8.1.7) database using RODBC as follows;
> dbConn <-
>
odbcConnect("mydatabase","myuserid","mypassword",case="oracle")
> Then I extract some data, actually a whole table;
> orgdata <- sqlQuery(dbConn, "select * from organism",
na.strings = "NA")
>
> Then I try to save it back;
> sqlSave(dbConn, orgdata, rownames="cols", verbose = TRUE)
> and I get the following error;
> Error in coldata[, 1] : incorrect number of dimensions
> I'm not well versed in R and I am afraid I don't understand this
error.
> Can anyone help?
>
> Gavin K.
>
> Gavin Kennedy
> Software Engineer - Bioinformatics
> CSIRO Mathematical and Information Sciences
> Gavin.Kennedy at CMIS.CSIRO.AU
> ph: 612-6246-4929
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._