Hi Thanks for the reply. I managed to find a simpler solution using RJDBC. All I needed to do was install RJDBC, DBI and download oracle driver for JDBC.
Regards Siddharth On Thu, Oct 14, 2010 at 5:32 PM, Marc Schwartz <marc_schwa...@me.com> wrote: > On Oct 14, 2010, at 12:45 AM, siddharth.gar...@gmail.com wrote: > > > Hi > > > > Can someone please help me with connecting to oracle via R. I have been > trying to use ROracle but its giving me a lot of trouble because of pro*c. > > > > Thanks&Regards > > Siddharth > > > You have not provided sufficient information (OS, error messages, what you > have done so far, etc.) to enable us to help you. Review the Posting Guide: > > > http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html> > > To start, be sure to read: > > http://cran.r-project.org/web/packages/ROracle/INSTALL > > I would also recommend searching the list archives, using one of the R > search tools such as: > > http://www.rseek.org/ > > using "ROracle" as a keyword. > > Depending upon your platform, you may wish to consider using the RODBC > package instead, which I have used on Linux and OSX to connect to Oracle > servers. > > Finally, there is the R-SIG-DB list, which is focused on R and database > connectivity/usage. More information is here: > > https://stat.ethz.ch/mailman/listinfo/r-sig-db > > I would recommend subscribing to that list and re-posting your query there, > with additional details, once you have reviewed the above resources. > > HTH, > > Marc Schwartz > > [[alternative HTML version deleted]] ______________________________________________ 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.