[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: =?UTF-8?Q?Re:_[ADMIN]_Re:_Problem_With_using_PERL::DBI_in_plperlu?=
From: Tomasz_Olszak <tolszak () o2 ! pl>
Date: 2009-02-26 13:56:32
Message-ID: 1d4714d.13274498.49a69f90.66027 () o2 ! pl
[Download RAW message or body]
Mónica, thanks for reply
I didn't install client, and i don't know how to check if it's instant or complete. \
What I can do is: [CODE]
TOlszak@heman:/opt/oracle> sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 26 14:40:01 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
[/CODE]
and size $ORACLE_BASE catalog is 1.6 GB.
I suppose it's complete then.
Dnia 26 lutego 2009 13:22 Mónica Gamarra <monica.gamarra@gmail.com> \
napisał(a): Tomaszwhich oracle client did yoou install?
we found that dbi don't work with instant client and it does with the complete \
client. 2009/2/24 Tomasz Olszak <tolszak@o2.pl>
Than you for Your answer Robert.
I've trying a lot of different configurations and the same perl body that works in OS \
perl script but doesn't work in plperlu function. I think it's a little bit confusing \
that almost all examples in Internet showing creating connection from postgres to \
oracle the way I did it. It seems that nobody tried to connect (from plperlu \
function) with external database(not installed on localhost and not in local \
network). Version Of perl that i'm using is 5.8.8, postgresql 8.2.9, oracle 10.2 \
client and DBI version is 1.52. I'll try to install latest DBI and perl.
If it's plperlu problem i will not try with latest postgresql because databases and \
application i'm using i too big to change source code of pg functions and application \
in few days to work with 8.3.* databases. If I find any solutions i will write an \
answer. Greetings
Tomek
There is a bug somewhere in the plperlu <-> oracle dbi stack (most likely in
the oracle dbd driver, but that just a guess) that prevents these type of
connections from work from a non-local connection, specifically due to lack
of environment variable sanity. We spent quite a bit of time trying to figure
this out a few years ago, but to no avail, so generally my answer on this
is "you can't do that", but by all means feel free to dig in and post if you
find a way to make it work (I'm hopeful that newer versions of the software
involved might work, but haven't had any luck in the combinations I've tested
so far).
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
............................................
Mónica Gamarra Barrios
monica.gamarra@gmail.com
[Attachment #3 (text/html)]
Mónica, thanks for reply<br /><br />I didn't install client, and i don't know how to \
check if it's instant or complete. What I can do is:<br />[CODE]<br \
/>TOlszak@heman:/opt/oracle> sqlplus /nolog<br /><br />SQL*Plus: Release \
10.2.0.1.0 - Production on Thu Feb 26 14:40:01 2009<br /><br />Copyright (c) 1982, \
2005, Oracle. All rights reserved.<br />[/CODE]<br /><br />and size $ORACLE_BASE \
catalog is 1.6 GB.<br /><br />I suppose it's complete then.<br /><br />Dnia 26 lutego \
2009 13:22 Mónica Gamarra <monica.gamarra@gmail.com> napisał(a):<br /><br /> \
<blockquote style="padding-left: 1em; margin-left: 1em; margin-bottom:0px; \
border-left: #ccc 2px solid;"> <div id="msg">
<div id="msg-body">
<div>Tomasz</div>
<div>which oracle client did yoou install?<br />we found that dbi don't work with \
instant client and it does with the complete client.</div> <div></div>
<div><br /></div>
<div class="gmail_quote">2009/2/24 Tomasz Olszak <span \
dir="ltr"><tolszak@o2.pl></span><br /> <blockquote class="gmail_quote" \
style="padding-left: 1ex; margin: 0px 0px 0px 0.8ex; border-left: #ccc 1px \
solid">Than you for Your answer Robert.<br /><br />I've trying a lot of different \
configurations and the same perl body that works in OS perl script but doesn't work \
in plperlu function.<br /><br />I think it's a little bit confusing that almost all \
examples in Internet showing creating connection from postgres to oracle the way I \
did it.<br /><br />It seems that nobody tried to connect (from plperlu function) with \
external database(not installed on localhost and not in local network).<br /><br \
/>Version Of perl that i'm using is 5.8.8, postgresql 8.2.9, oracle 10.2 client and \
DBI version is 1.52.<br /><br />I'll try to install latest DBI and perl.<br />If it's \
plperlu problem i will not try with latest postgresql because databases and \
application i'm using i too big to change source code of pg functions and application \
in few days to work with 8.3.* databases.<br /><br />If I find any solutions i will \
write an answer.<br /><br />Greetings<br /><br />Tomek <div>
<div class="Wj3C7c"><br /><br /><br />
<blockquote style="padding-left: 1em; margin-bottom: 0px; margin-left: 1em; \
border-left: #ccc 2px solid">There is a bug somewhere in the plperlu <-> oracle \
dbi stack (most likely in<br />the oracle dbd driver, but that just a guess) that \
prevents these type of<br />connections from work from a non-local connection, \
specifically due to lack<br />of environment variable sanity. We spent quite a bit of \
time trying to figure<br />this out a few years ago, but to no avail, so generally my \
answer on this<br />is "you can't do that", but by all means feel free to dig in and \
post if you<br />find a way to make it work (I'm hopeful that newer versions of the \
software<br />involved might work, but haven't had any luck in the combinations I've \
tested<br />so far).<br /><br />--<br />Robert Treat<br />Conjecture: <a \
href="http://www.xzilla.net/" target="_blank">http://www.xzilla.net</a><br \
/>Consulting: <a href="http://www.omniti.com/" \
target="_blank">http://www.omniti.com</a><br /></blockquote> </div>
</div>
</blockquote>
</div>
<br /><br /><br />--<br />............................................<br />Mónica \
Gamarra Barrios<br /><a href="mailto:monica.gamarra@gmail.com" \
target="_blank">monica.gamarra@gmail.com</a><br /></div> </div>
</blockquote>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic