Thank you David. I must say, I find mailing lists extremely confusing, and wish there was a "proper" forum type place to go to! My apologies for mailing to the wrong place: I am now not sure whether to keep it here or not! I only wrote here after noting that previous questions about DBI-Link (some going back to 2005, admittedly) were posted here -but, as I say, apologies if that was wrong.
Anyway: I have been using the version 2.0.0 of the DBI-Link, which was last updated three years ago. I see from your link that there are 2010 files available, so I'll definitely give that a whirl. @Alexander: yes, my server is configured properly. At least, the postgres user and the root user (as well as the oracle user) can all use SQL*Plus to connect to the remote database without having to set any *additional* environment variables, as I mentioned originally. Quite what else I'm supposed to set, if anything, I can't imagine! I do note, however, that after I run the DBI-Link SQL statements, I get nothing at all in the dbi_link.dbi_connection_environment table, which is probably why it's not working the second time around. Why the function being called can't read the environment variables which are most definitely set, or why it can't insert what it's read into the relevant table, I have no idea. I'll try with the latest software David linked to and see how I get on. Thanks to you both, HJR On Thu, Jul 1, 2010 at 5:24 AM, David Fetter <da...@fetter.org> wrote: > On Wed, Jun 30, 2010 at 10:10:02AM +1000, Howard Rogers wrote: > > I am stumped, despite working on this for a week! I am trying to create a > > 64-bit postgresql 8.4 database server which can retrieve data from > various > > 64-bit Oracle 10gR2 and 11gR2 databases. > > Try downloading the latest version of DBI-Link using the "Download > Source" link at <http://github.com/davidfetter/DBI-Link> > > There is also a low-traffic mailing list for the project, where > questions like this are more on point :) > > Cheers, > David. > -- > David Fetter <da...@fetter.org> http://fetter.org/ > Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter > Skype: davidfetter XMPP: david.fet...@gmail.com > iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics > > Remember to vote! > Consider donating to Postgres: http://www.postgresql.org/about/donate > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
