Re: DBI::Oracle problems

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 <david(at)fetter(dot)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 <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
> Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>