[R] RODBC SQLSave

[Gavin Kennedy]

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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._