Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9051463424C for ; Thu, 26 Feb 2009 09:56:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 86616-02 for ; Thu, 26 Feb 2009 09:56:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailout1.go2.pl (mailout1.go2.pl [193.17.41.11]) by mail.postgresql.org (Postfix) with ESMTP id 11713634217 for ; Thu, 26 Feb 2009 09:56:48 -0400 (AST) Received: from mailout1.go2.pl (unknown [10.0.0.104]) by mailout1.go2.pl (Postfix) with ESMTP id 7DDCB30048; Thu, 26 Feb 2009 14:56:33 +0100 (CET) Received: from o2.pl (unknown [10.0.0.37]) by mailout1.go2.pl (Postfix) with SMTP; Thu, 26 Feb 2009 14:56:33 +0100 (CET) Subject: =?UTF-8?Q?Re:__Re:_Problem_With_using_PERL::DBI_in_plperlu?= =?UTF-8?Q?_function?= From: =?UTF-8?Q?Tomasz_Olszak?= To: =?UTF-8?Q?M=C3=B3nica_Gamarra?= Cc: pgsql-admin@postgresql.org In-Reply-To: References: <57da2175.1ad3af61.49a26c33.ce91@o2.pl> <200902231530.19579.xzilla@users.sourceforge.net> <644a8ae7.2fd54209.49a3b009.acc13@o2.pl> Mime-Version: 1.0 Message-ID: <1d4714d.13274498.49a69f90.66027@o2.pl> Date: Thu, 26 Feb 2009 14:56:32 +0100 X-Originator: 83.18.171.115 Content-Type: multipart/alternative; boundary="==o2.pl-WebMail-1828e27a.3e9d0bc6.66035==" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200902/236 X-Sequence-Number: 31457 --==o2.pl-WebMail-1828e27a.3e9d0bc6.66035== Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable M=C3=B3nica,=20thanks=20for=20reply I=20didn't=20install=20client,=20and=20i=20don't=20know=20how=20to=20chec= k=20if=20it's=20instant=20or=20complete.=20What=20I=20can=C2=A0=20do=20is= : [CODE] TOlszak@heman:/opt/oracle>=20sqlplus=20/nolog SQL*Plus:=20Release=2010.2.0.1.0=20-=20Production=20on=20Thu=20Feb=2026=20= 14:40:01=202009 Copyright=20(c)=201982,=202005,=20Oracle.=C2=A0=20All=20rights=20reserved= . [/CODE] and=20size=20$ORACLE=5FBASE=20catalog=20is=201.6=20GB. I=20suppose=20it's=20complete=20then. Dnia=2026=20lutego=202009=2013:22=20M=C3=B3nica=20Gamarra=20<monica.ga= marra@gmail.com>=20napisa=C5=82(a): Tomaszwhich=20oracle=20client=20did=20yoou=20install? we=20found=20that=20dbi=20don't=20work=20with=20instant=20client=20and=20= it=20does=20with=20the=20complete=20client. 2009/2/24=20Tomasz=20Olszak=20<tolszak@o2.pl> Than=20you=20for=20Your=20answer=20Robert. I've=20trying=20a=20lot=20of=20different=20configurations=20and=20the=20s= ame=20perl=20body=20that=20works=20in=20OS=20perl=20script=20but=20doesn'= t=20work=20in=20plperlu=20function. I=20think=20it's=20a=20little=20bit=20confusing=20that=20almost=20all=20e= xamples=20in=20Internet=20showing=20creating=20connection=20from=20postgr= es=20to=20oracle=20the=20way=20I=20did=20it. It=20seems=20that=20nobody=20tried=20to=20connect=20(from=20plperlu=20fun= ction)=20with=20external=20database(not=20installed=20on=20localhost=20an= d=20not=20in=20local=20network). Version=20Of=20perl=20that=20i'm=20using=20is=205.8.8,=20postgresql=208.2= .9,=20oracle=2010.2=20client=20and=20DBI=20version=20is=201.52. I'll=20try=20to=20install=20latest=20DBI=20and=20perl. If=20it's=20plperlu=20problem=20i=20will=20not=20try=20with=20latest=20po= stgresql=20because=20databases=20and=20application=20i'm=20using=20i=20to= o=20big=20to=20change=20source=20code=20of=20pg=20functions=20and=20appli= cation=20in=20few=20days=20to=20work=20with=208.3.*=20databases. If=20I=20find=20any=20solutions=20i=20will=20write=20an=20answer. Greetings Tomek There=20is=20a=20bug=20somewhere=20in=20the=20plperlu=20<->=20oracl= e=20dbi=20stack=20(most=20likely=20in the=20oracle=20dbd=20driver,=20but=20that=20just=20a=20guess)=20that=20pr= events=20these=20type=20of connections=20from=20work=20from=20a=20non-local=20connection,=20specific= ally=20due=20to=20lack of=20environment=20variable=20sanity.=20We=20spent=20quite=20a=20bit=20of= =20time=20trying=20to=20figure this=20out=20a=20few=20years=20ago,=20but=20to=20no=20avail,=20so=20gener= ally=20my=20answer=20on=20this is=20"you=20can't=20do=20that",=20but=20by=20all=20means=20feel=20free=20= to=20dig=20in=20and=20post=20if=20you find=20a=20way=20to=20make=20it=20work=20(I'm=20hopeful=20that=20newer=20= versions=20of=20the=20software involved=20might=20work,=20but=20haven't=20had=20any=20luck=20in=20the=20= combinations=20I've=20tested so=20far). -- Robert=20Treat Conjecture:=20http://www.xzilla.net Consulting:=20http://www.omniti.com -- ............................................ M=C3=B3nica=20Gamarra=20Barrios monica.gamarra@gmail.com --==o2.pl-WebMail-1828e27a.3e9d0bc6.66035== Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable M=C3=B3nica,=20thanks=20for=20replyI=20didn't=20install=20= client,=20and=20i=20don't=20know=20how=20to=20check=20if=20it's=20instant= =20or=20complete.=20What=20I=20can=C2=A0=20do=20is:[CODE]= TOlszak@heman:/opt/oracle>=20sqlplus=20/nologSQL*Plus:= =20Release=2010.2.0.1.0=20-=20Production=20on=20Thu=20Feb=2026=2014:40:01= =202009Copyright=20(c)=201982,=202005,=20Oracle.=C2=A0=20= All=20rights=20reserved.[/CODE]and=20size=20$ORAC= LE=5FBASE=20catalog=20is=201.6=20GB.I=20suppose=20it's=20= complete=20then.Dnia=2026=20lutego=202009=2013:22=20M=C3=B3= nica=20Gamarra=20<monica.gamarra@gmail.com>=20napisa=C5=82(a):
Tomasz
which=20oracle=20client=20did=20yoou=20install?we=20found=20= that=20dbi=20don't=20work=20with=20instant=20client=20and=20it=20does=20w= ith=20the=20complete=20client.
2009/2/24=20Tomasz=20Olszak=20<tolszak@o2.pl> Th= an=20you=20for=20Your=20answer=20Robert.I've=20trying=20a= =20lot=20of=20different=20configurations=20and=20the=20same=20perl=20body= =20that=20works=20in=20OS=20perl=20script=20but=20doesn't=20work=20in=20p= lperlu=20function.I=20think=20it's=20a=20little=20bit=20c= onfusing=20that=20almost=20all=20examples=20in=20Internet=20showing=20cre= ating=20connection=20from=20postgres=20to=20oracle=20the=20way=20I=20did=20= it.It=20seems=20that=20nobody=20tried=20to=20connect=20(f= rom=20plperlu=20function)=20with=20external=20database(not=20installed=20= on=20localhost=20and=20not=20in=20local=20network).Versio= n=20Of=20perl=20that=20i'm=20using=20is=205.8.8,=20postgresql=208.2.9,=20= oracle=2010.2=20client=20and=20DBI=20version=20is=201.52.= I'll=20try=20to=20install=20latest=20DBI=20and=20perl.If=20it's=20= plperlu=20problem=20i=20will=20not=20try=20with=20latest=20postgresql=20b= ecause=20databases=20and=20application=20i'm=20using=20i=20too=20big=20to= =20change=20source=20code=20of=20pg=20functions=20and=20application=20in=20= few=20days=20to=20work=20with=208.3.*=20databases.If=20I=20= find=20any=20solutions=20i=20will=20write=20an=20answer.G= reetingsTomek
There=20is=20a=20bu= g=20somewhere=20in=20the=20plperlu=20<->=20oracle=20dbi=20stack=20(= most=20likely=20inthe=20oracle=20dbd=20driver,=20but=20that=20jus= t=20a=20guess)=20that=20prevents=20these=20type=20ofconnections=20= from=20work=20from=20a=20non-local=20connection,=20specifically=20due=20t= o=20lackof=20environment=20variable=20sanity.=20We=20spent=20quit= e=20a=20bit=20of=20time=20trying=20to=20figurethis=20out=20a=20fe= w=20years=20ago,=20but=20to=20no=20avail,=20so=20generally=20my=20answer=20= on=20thisis=20"you=20can't=20do=20that",=20but=20by=20all=20means= =20feel=20free=20to=20dig=20in=20and=20post=20if=20youfind=20a=20= way=20to=20make=20it=20work=20(I'm=20hopeful=20that=20newer=20versions=20= of=20the=20softwareinvolved=20might=20work,=20but=20haven't=20had= =20any=20luck=20in=20the=20combinations=20I've=20testedso=20far).= --Robert=20TreatConjecture:=20http://www.xzilla.net<= br=20/>Consulting:=20http://www.omniti.com
--.......................................= .....M=C3=B3nica=20Gamarra=20Barriosmonica.gamarra@gmail.com --==o2.pl-WebMail-1828e27a.3e9d0bc6.66035==--