On 24/10/2008 7:52 AM, Rita. A wrote:
Hello All,

I get the following error when i run the following script in Rgui

Rgui.exe - Application Error

The instruction at "0x7c9109f9" referenced memory at "0xffffffff". The
memory could not be "read"
Click on OK to terminate the program

The script is

library(RODBC)
channel <- odbcConnect("curve", uid="curve", pwd="curve")
elastic <- sqlFetch(channel,"elasticband")
attach(elastic)
png(filename="e:/R/cf.png")
plot(spline(distance~stretch),type="l",xlab="Stretch",ylab="Distance")
odbcClose(channel)

I use R version 2.7.2 and using RODBC to fetch data from Oracle 10g, I would
appreciate any help

This is unlikely to be easy to fix. It depends on R, the RODBC code, the ODBC driver for Oracle, and Oracle itself. There are 3 or 4 separate authors involved who will all blame the others.

I'll be first: it's probably not R. And since Brian Ripley is away now, I'll cover for him too: it's probably not RODBC.

So you should contact Oracle tech support for their denials.

Seriously, debugging this requires resources which probably only Oracle has, but which Oracle probably won't devote to the problem. So if you don't get satisfaction from them I'd suggest dumping the database and reloading it in some other database. Hopefully a free/open source one.

Duncan Murdoch

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to