[R] RE: ROracle on RHEL 3 x86_64

[mark.threefoot@amd.com]

Hello,

I have gotten past the segmentation fault issue.  I needed to set the environment variable LD_PRELOAD to libclntsh.so.9.0.  I still have another issue, whenever I query the database I get back an empty result set.  Has anyone come across this?  Here is the example code that I am using:

> library('ROracle')
> ora <- Oracle()
> con <- dbConnect(ora, "username/password at database")
> rs <- dbGetQuery(con, "select x, g from R_TEST")
> rs
<Expired OraResult:(7115,0,1)>

or alternatively:

> library('ROracle')
> ora <- Oracle()
> con <- dbConnect(ora, "username/password at database")
> res <- dbSendQuery(con, statement = paste("SELECT X, G FROM R_TEST"))
> res
<OraResult:(7054,0,1)>
> data1 <- fetch(res, n = 100)
Warning message: 
no more records to fetch in: oraFetch(res, n, ...) 
> data1
NULL data frame with 0 rows
> dim(data1)
[1] 0 0

Thanks,
Mark Threefoot

	 -----Original Message-----
	From: 	Threefoot, Mark  
	Sent:	Monday, May 24, 2004 1:37 PM
	To:	'r-help at stat.math.ethz.ch'
	Subject:	ROracle on RHEL 3 x86_64


	Hello,

	I am trying to configure my system with ROracle.  I am running RHEL 3 AS x86_64.  I have the Oracle client 9.2.0.4 x86_64.  I have successfully compiled and run both R-1.8.1 and R-1.9.0 (tried ROracle on both installations).  I am using DBI 1.8 and ROracle 0.5-4.  I have used both the default Redhat installed gcc 3.2.3 and gcc 3.4.  I am able to compile ROracle successfully with the following command:

	R CMD INSTALL --configure-args='--enable-extralibs="-lsqlplus"' ROracle_0.5-4.tar.gz

	When I run R, I get a Segmentation fault after the dbConnect call:

	> library('ROracle')
	> ora <- Oracle()
	> con <- dbConnect(ora, "username/password at database")
	Segmentation fault (core dumped)

	Has anyone run into this, or are running the same configuration?  Any help would be appreciated.

	Thanks,
	Mark Threefoot 
	mark.threefoot at amd.com