[R] Oracle and RJDBC
slsmyl at yahoo.com.au
Sat Oct 27 11:30:23 CEST 2007
I am using Oracle 10.2 and R 2.6 on Windows XP.
I found RODBC working generally OK (with some minor problems) but very slow, so I am trying to use RJDBC.
While getting things (dbGetQuery) works fine, I have problems with saving:
dbWriteTable(conn, "WAV", save_df, overwrite = F, append = T, row.names=F)
will fail with
execute JDBC update query failed in dbSendUpdate (ORA-01000: maximum open cursors exceeded
Now, I do not believe that my limit of 300 open cursors has been exceeded - it is only me who uses this Oracle instance and anyway RODBC works (although slowly).
The data frame has a few columns and around two thousand rows. Table WAV is automatically created, but remains empty.
I would be grateful if someone could help me,
Sick of deleting your inbox? Yahoo!7 Mail has free unlimited storage.
More information about the R-help