[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] DBI::Oracle problems
From: Howard Rogers <hjr () diznix ! com>
Date: 2010-06-30 23:49:12
Message-ID: AANLkTily7_5Fz4c_ZTDvIG7406MvMDMzXkZYr8zX8bKW () mail ! gmail ! com
[Download RAW message or body]
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@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 <david@fetter.org> http://fetter.org/
> Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
> Skype: davidfetter XMPP: david.fetter@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
>
[Attachment #3 (text/html)]
Thank you David.<div><br></div><div>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.</div>
<div><br></div><div>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.</div>
<div><br></div><div>@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!</div>
<div><br></div><div>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. \
</div>
<div><br></div><div>I'll try with the latest software David linked to and see how \
I get on.</div><div><br></div><div>Thanks to you both,</div><div>HJR<br> <br><div \
class="gmail_quote">On Thu, Jul 1, 2010 at 5:24 AM, David Fetter <span \
dir="ltr"><<a href="mailto:david@fetter.org" \
target="_blank">david@fetter.org</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">
<div>On Wed, Jun 30, 2010 at 10:10:02AM +1000, Howard Rogers wrote:<br>
> I am stumped, despite working on this for a week! I am trying to create a<br>
> 64-bit postgresql 8.4 database server which can retrieve data from various<br>
> 64-bit Oracle 10gR2 and 11gR2 databases.<br>
<br>
</div>Try downloading the latest version of DBI-Link using the "Download<br>
Source" link at <<a href="http://github.com/davidfetter/DBI-Link" \
target="_blank">http://github.com/davidfetter/DBI-Link</a>><br> <br>
There is also a low-traffic mailing list for the project, where<br>
questions like this are more on point :)<br>
<br>
Cheers,<br>
David.<br>
<font color="#888888">--<br>
David Fetter <<a href="mailto:david@fetter.org" \
target="_blank">david@fetter.org</a>> <a href="http://fetter.org/" \
target="_blank">http://fetter.org/</a><br>
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter<br>
Skype: davidfetter XMPP: <a href="mailto:david.fetter@gmail.com" \
target="_blank">david.fetter@gmail.com</a><br>
iCal: webcal://<a href="http://www.tripit.com/feed/ical/people/david74/tripit.ics" \
target="_blank">www.tripit.com/feed/ical/people/david74/tripit.ics</a><br> <br>
Remember to vote!<br>
Consider donating to Postgres: <a href="http://www.postgresql.org/about/donate" \
target="_blank">http://www.postgresql.org/about/donate</a><br> \
</font><div><div></div><div><br>
--<br>
Sent via pgsql-general mailing list (<a href="mailto:pgsql-general@postgresql.org" \
target="_blank">pgsql-general@postgresql.org</a>)<br> To make changes to your \
subscription:<br> <a href="http://www.postgresql.org/mailpref/pgsql-general" \
target="_blank">http://www.postgresql.org/mailpref/pgsql-general</a><br> \
</div></div></blockquote></div><br></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic