Re: (Fwd) DBD:Oracle

2020-11-26 Thread Jared Still
$ORACLE_HOME/perl/bin/perl -MDBD::Oracle=99 Jared On Mon, Jul 13, 2020 at 14:29 Tim Bunce wrote: > - Forwarded message from Ajay Kumar - > > Date: Mon, 13 Jul 2020 15:32:55 + > From: Ajay Kumar > To: Tim Bunce > Subject: DBD:Oracle > >Hi Tim, >Hope, you a

(Fwd) DBD:Oracle

2020-07-13 Thread Tim Bunce
- Forwarded message from Ajay Kumar - Date: Mon, 13 Jul 2020 15:32:55 + From: Ajay Kumar To: Tim Bunce Subject: DBD:Oracle Hi Tim, Hope, you are sound and safe with your loved ones. I am trying to install the ORA2PG tool which migrates Oracle data into PostgreSQL

Re: I probably mentioned this the last time I installed DBD:Oracle but I couldn't find it...

2017-10-22 Thread Christopher Jones
On 18/10/17 8:06 am, Bruce Johnson wrote: Oracle’s latest instant client for 64-bit linux puts the demo.mk file in /usr/share/oracle/12.2/client64/demo The DBD::Oracle installer only looks in /usr/share/oracle/12.2/client64/ to find it and thus installing from cpan fails. Dunno if this is

I probably mentioned this the last time I installed DBD:Oracle but I couldn't find it...

2017-10-17 Thread Bruce Johnson
Oracle’s latest instant client for 64-bit linux puts the demo.mk file in /usr/share/oracle/12.2/client64/demo The DBD::Oracle installer only looks in /usr/share/oracle/12.2/client64/ to find it and thus installing from cpan fails. Dunno if this is really a reportable bug or not. I just put

Re: DBD:Oracle compilation failure

2012-03-20 Thread Martin J. Evans
On 19/03/12 22:56, J.V. wrote: I am trying to compile DBD Oracle under cygwin and I get the following error message: (any ideas?) What is broke? I'm on cygwin / Window 7 --- Using DBI 1.618 (for perl 5.010001 on i686-cygwin-thread-multi-64int) installed in

how to get DBD:Oracle and DBD:PostgreSQL working under cygwin/Windows 7

2012-03-19 Thread J.V.
I am attempting to get DBD:Oracle and DBD:Postgres to work under Windows 7 via cygwin. I was able to successfully install DBI, but the database specific modules fail. I am doing: $perl Makefile.pl $make $make test $make install Both Oracle Postgres are failing on the make. I really need

DBD:Oracle compilation failure

2012-03-19 Thread J.V.
I am trying to compile DBD Oracle under cygwin and I get the following error message: (any ideas?) What is broke? I'm on cygwin / Window 7 --- Using DBI 1.618 (for perl 5.010001 on i686-cygwin-thread-multi-64int) installed in /usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI/ Configuring

Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

2011-12-13 Thread kiran kumar
that the root perl cheers John Date: Fri, 9 Dec 2011 13:48:41 -0600 From: mn...@genome.wustl.edu To: kirankumar...@gmail.com CC: dbi-users@perl.org Subject: Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine kiran, Sounds like a permission issue with the oracle library

Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

2011-12-12 Thread kiran kumar
John Date: Fri, 9 Dec 2011 13:48:41 -0600 From: mn...@genome.wustl.edu To: kirankumar...@gmail.com CC: dbi-users@perl.org Subject: Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine kiran, Sounds like a permission issue with the oracle library. Make sure the library

Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

2011-12-12 Thread Martin J. Evans
On 09/12/11 13:40, kiran kumar wrote: Hi, I have installed DBD:Oracle 1.34 module on 64 bit Linux machine with root user and when I run it root user its working file, But when I run it using non root user, I am getting the error “install_driver(Oracle) failed: Can't load '/usr/lib64/perl5

Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

2011-12-09 Thread kiran kumar
Hi, I have installed DBD:Oracle 1.34 module on 64 bit Linux machine with root user and when I run it root user its working file, But when I run it using non root user, I am getting the error “install_driver(Oracle) failed: Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread

Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

2011-12-09 Thread Michael Nhan
if its not install in the standard library path. michael On Fri, 9 Dec 2011, kiran kumar wrote: Date: Fri, 9 Dec 2011 19:10:50 +0530 From: kiran kumar kirankumar...@gmail.com To: dbi-users@perl.org Subject: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine Hi, I have installed

RE: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

2011-12-09 Thread John Scoles
...@genome.wustl.edu To: kirankumar...@gmail.com CC: dbi-users@perl.org Subject: Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine kiran, Sounds like a permission issue with the oracle library. Make sure the library is accessible by the user running the script. Make sure

Re: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-25 Thread Alexander Foken
had a broader test page for the Release Cadidates, hint hint nudge nudge ;) ;) Cheers John Scoles Date: Thu, 24 Mar 2011 13:27:20 +0100 From: alexan...@foken.de To: dbi-users@perl.org CC: jason.thurs...@gmail.com Subject: Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W DBD::Oracle 1.27

Re: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-25 Thread Alexander Foken
of caught this if we had a broader test page for the Release Cadidates, hint hint nudge nudge ;) ;) Cheers John Scoles Date: Thu, 24 Mar 2011 13:27:20 +0100 From: alexan...@foken.de To: dbi-users@perl.org CC: jason.thurs...@gmail.com Subject: Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W DBD

Re: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-25 Thread Martin J. Evans
Scoles Date: Thu, 24 Mar 2011 13:27:20 +0100 From: alexan...@foken.de To: dbi-users@perl.org CC: jason.thurs...@gmail.com Subject: Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W DBD::Oracle 1.27 compiled, tested and installed without any problems. The changes in URL:http://search.cpan.org/~pythian

Re: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-25 Thread Alexander Foken
On 25.03.2011 11:13, Martin J. Evans wrote: On 25/03/11 09:28, Alexander Foken wrote: Adding the line to oci.def helped, DBD::Oracle 1.28 compiles fine with the patch on W2K / Strawberry 5.12 / Oracle 10.2g. The test t/26exe_array.t failes due to a bad plan, 406 test planned, but 407 tests

Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-24 Thread Alexander Foken
Hello, sorry, just a me too posting. I was just about to ask for nearly(?) the same problem. I'm trying with Strawberry Perl 5.12.2.0 and 5.10.0.4, Oracle 10g, DBD::Oracle 1.28, Windows 2000 Professional. Final problem after tons of warnings: oci8.o: oci8.c: undefined reference to

Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-24 Thread Steffen Goeldner
Jason Thurston wrote: Hello, Does anyone have any ideas where to go from here? I think perl Makefile.PL is successful but I get an error when trying the next step make. The Error I get when trying to make is /home/foo/DBD-Oracle-1.28/oci8.c:4619: undefined reference to `_OCIServerRelease'.

Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-24 Thread Alexander Foken
DBD::Oracle 1.27 compiled, tested and installed without any problems. The changes in URL:http://search.cpan.org/~pythian/DBD-Oracle-1.28/Changes#Changes_in_DBD-Oracle_1.28_%28svn_rev_14765%29 don't look relevant to my environment. I can live with that. Now it is clear that some change from

RE: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-24 Thread John Scoles
for the Release Cadidates, hint hint nudge nudge ;) ;) Cheers John Scoles Date: Thu, 24 Mar 2011 13:27:20 +0100 From: alexan...@foken.de To: dbi-users@perl.org CC: jason.thurs...@gmail.com Subject: Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W DBD::Oracle 1.27 compiled, tested and installed

Re: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-24 Thread Jason Thurston
@perl.org CC: jason.thurs...@gmail.com Subject: Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W DBD::Oracle 1.27 compiled, tested and installed without any problems. The changes in URL:http://search.cpan.org/~pythian/DBD-Oracle-1.28/Changes#Changes_in_DBD-Oracle_1.28_%28svn_rev_14765%29 don't look

Re: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-24 Thread Jason Thurston
From: alexan...@foken.de To: dbi-users@perl.org CC: jason.thurs...@gmail.com Subject: Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W DBD::Oracle 1.27 compiled, tested and installed without any problems. The changes in URL:http://search.cpan.org/~pythian/DBD-Oracle-1.28/Changes

Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-23 Thread Jason Thurston
Hello, Does anyone have any ideas where to go from here? I think perl Makefile.PL is successful but I get an error when trying the next step make. The Error I get when trying to make is /home/foo/DBD-Oracle-1.28/oci8.c:4619: undefined reference to `_OCIServerRelease'.  See Below for details. I

Re: centos perl-DBD:Oracle

2010-04-29 Thread Michael Ludwig
Am 29.04.2010 um 04:08 schrieb Pam Wampler: What are the steps to install perl-DBD:Oracle on a centos 5 server? rpm -i perl-DBD-Oracle-1.19-1.el5.i386.rpm warning: perl-DBD-Oracle-1.19-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e42d547b error: Failed dependencies

Re: centos perl-DBD:Oracle

2010-04-29 Thread Kim
Hi Pam, Pam Wampler wrote: What are the steps to install perl-DBD:Oracle on a centos 5 server? I have the following oracle rpm's installed rpm -qa | grep oracle oracle-instantclient11.2-odbc-11.2.0.1.0-1 oracle-instantclient-sqlplus-10.2.0.3-1 oracle-instantclient-basic-10.2.0.3-1 oracle

centos perl-DBD:Oracle

2010-04-28 Thread Pam Wampler
What are the steps to install perl-DBD:Oracle on a centos 5 server? I have the following oracle rpm's installed rpm -qa | grep oracle oracle-instantclient11.2-odbc-11.2.0.1.0-1 oracle-instantclient-sqlplus-10.2.0.3-1 oracle-instantclient-basic-10.2.0.3-1 oracle-instantclient11.2

Re: parameter issues in DBD:Oracle

2010-03-27 Thread Peter J. Holzer
On 2010-03-26 11:13:14 -0700, Bruce Johnson wrote: On Mar 26, 2010, at 11:01 AM, Bruce Johnson wrote: Does the DBD enclose all parameters in ''s? Not really. It passes the parameters separately from the query. Am I actually trying to execute: select reserved_id, reserver, purpose,

Re: parameter issues in DBD:Oracle

2010-03-27 Thread Bart Lateur
On Fri, 26 Mar 2010 14:32:52 -0400, Bobak, Mark wrote: Is there a way to pass an unquoted list as a parameter? I can't do it as 'in(?,?,?,?)' etc, because the number of list elements varies from execution to execution. There's a special feature in DBIx::Simple to tackle this exact case. Look

parameter issues in DBD:Oracle

2010-03-26 Thread Bruce Johnson
I'm trying the following: $sqcollision = select reserved_id, reserver, purpose, to_char(starttime, 'HH:MI'), to_char(stoptime, 'HH:MI') from reservedroomtest where roomid in (?) and ((to_date(?, 'MM/DD/ HH24:MM') = starttime and to_date(?, 'MM/DD/ HH24:MM') = starttime) or

Re: parameter issues in DBD:Oracle

2010-03-26 Thread m. allan noah
You cannot pack a comma separated list into a single ?, because they will be wrapped together in one set of quotes. Use multiple ? in your 'in()' clause, and send each item individually into execute(). allan On Fri, Mar 26, 2010 at 2:01 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote: I'm

Re: parameter issues in DBD:Oracle

2010-03-26 Thread Bruce Johnson
On Mar 26, 2010, at 11:01 AM, Bruce Johnson wrote: Does the DBD enclose all parameters in ''s? Am I actually trying to execute: select reserved_id, reserver, purpose, to_char(starttime, 'HH:MI'), to_char(stoptime, 'HH:MI') from reservedroomtest where roomid in ('105, 106, 110') To

RE: parameter issues in DBD:Oracle

2010-03-26 Thread Bobak, Mark
One solution is here: http://asktom.oracle.com/pls/apex/f?p=100:11:0P11_QUESTION_ID:210612357425 -Original Message- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: Friday, March 26, 2010 2:13 PM Cc: dbi Mailing List Subject: Re: parameter issues in DBD:Oracle On Mar

Re: trouble installing DBD:Oracle on linux

2009-01-12 Thread Hendrik Schumacher
to make DBD:Oracle? Did it build? Did any tests fail? If no tests failed you are likely good to go. The warning you obviously refer to only affects one way DBD::Oracle uses to discover the build rules: WARNING: Oracle build rule discovery failed (512) Oracle oci build command

Re: trouble installing DBD:Oracle on linux

2009-01-11 Thread Harsha Hegde
Thanks for the response, Hendrik. What libraries should I look for? LD_LIBRARY_PATH has the following files: r...@devserver-165:~# echo $LD_LIBRARY_PATH /usr/vendor/pkg/oracle/product/10.2.0/lib r...@devserver-165:~# cd $LD_LIBRARY_PATH

trouble installing DBD:Oracle on linux

2009-01-09 Thread Harsha Hegde
Hi DBI users, I am trying to install DBD::Oracle on a x86 64bit machine running Ubuntu Linux. I see the following error: r...@devserver-165:~/.cpan/build/DBD-Oracle-1.22-4sDScg# perl Makefile.PL Using DBI 1.607 (for perl 5.01 on x86_64-linux) installed in

Re: trouble installing DBD:Oracle on linux

2009-01-09 Thread Hendrik Schumacher
Am Fr, 9.01.2009, 16:43, schrieb Harsha Hegde: Hi DBI users, I am trying to install DBD::Oracle on a x86 64bit machine running Ubuntu Linux. I see the following error: r...@devserver-165:~/.cpan/build/DBD-Oracle-1.22-4sDScg# perl Makefile.PL Using DBI 1.607 (for perl 5.01 on

DBD:Oracle

2008-07-31 Thread Frank.Hofmann
Hi, thanks for your advice - I installed ActivePerl-5.10.0.100 now, and the DBD::Oracle - package works fine now. Frank Atos Origin GmbH, Theodor-Althoff-Str. 47, D-45133 Essen, Postfach 100 123, D-45001 Essen Telefon: +49 201 4305 0, Fax: +49 201 4305 689095, www.atosorigin.de ING Bank AG,

Re: Urgent help required : Issue with DBD:Oracle 1.20 installation

2008-04-05 Thread Divyansh Nasa
Please respond to with DBD:Oracle 1.20 installation [EMAIL PROTECTED] m

Urgent help required : Issue with DBD:Oracle 1.20 installation

2008-04-04 Thread Divyansh Nasa
Hi all I am trying to install DBD-Oracle-1.20 downloaded from CPAN. I am getting the following errors. Request you to help asap [EMAIL PROTECTED] # perl Makefile.PL Using DBI 1.601 (for perl 5.008007 on sun4-solaris) installed in

Re: Urgent help required : Issue with DBD:Oracle 1.20 installation

2008-04-04 Thread John Scoles
oracle client use an older DBD::Oracle. You can also compile you DBD:Oracle against the Oracle instant client and it will work as well cheers John Scoles Divyansh Nasa wrote: Hi all I am trying to install DBD-Oracle-1.20 downloaded from CPAN. I am getting the following errors. Request you

Re: DBD:Oracle-1.19 Can't load Oracle.dll

2007-04-16 Thread Matthew Bygrave
Hi, I have a slight problem with the installation of DBD::Oracle 1.19 using the cygwin environment running on Win2003 R2 Standard edition sp1 machine. The version of Oracle I am using is 10.2.0 . Here is the output from make test command :

Re: DBD:Oracle-1.19 Can't load Oracle.dll

2007-04-16 Thread John Scoles
Do you have the path to your Oracle client in you Path statment?? Matthew Bygrave [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I have a slight problem with the installation of DBD::Oracle 1.19 using the cygwin environment running on Win2003 R2 Standard edition sp1 machine.

Re: DBD:Oracle 1.07 ref cursor

2006-10-10 Thread Tim Bunce
On Mon, Oct 09, 2006 at 04:49:12PM +0300, Eugene Krivdyuk wrote: Hi all. I'm having trouble with stored pl/sql function which returns ref cursor. This stored proc runs for 6 minutes while SQL itself executed for 6 seconds when executed outside pl/sql function. Possibly due to a bug where

RE: DBD:Oracle 1.07 ref cursor

2006-10-10 Thread Steve Baldwin
: Tuesday, 10 October 2006 6:54 PM To: Eugene Krivdyuk Subject: Re: DBD:Oracle 1.07 ref cursor On Mon, Oct 09, 2006 at 04:49:12PM +0300, Eugene Krivdyuk wrote: Hi all. I'm having trouble with stored pl/sql function which returns ref cursor. This stored proc runs for 6 minutes while SQL

DBD:Oracle 1.07 ref cursor

2006-10-09 Thread Eugene Krivdyuk
Hi all. I'm having trouble with stored pl/sql function which returns ref cursor. This stored proc runs for 6 minutes while SQL itself executed for 6 seconds when executed outside pl/sql function. Is there any way to speed things up without rewriting app without packages/stored procedures ? P.S.

Re: DBD:Oracle 1.07 ref cursor

2006-10-09 Thread rachakonda muralikrishna
  Hi I am unable to unsubscribe from this group. The mail bounces back. Pls help. Murali On Mon, 09 Oct 2006 Eugene Krivdyuk wrote : Hi all. I'm having trouble with stored pl/sql function which returns ref cursor. This stored proc runs for 6 minutes while SQL itself executed for 6 seconds

RE: ANNOUNCE: DBD:Oracle 1.18

2006-07-30 Thread Fox, Michael
John, Found this http://e-docs.bea.com/platform/suppconfigs/configs70/hptru64unix51_alpha/70s p1.html which explains the problem of the unresolved OCILobLocatorAssign. I got our DBA to include OCILobLocatorAssign as an entrypoint in the list, rebuilt libclntsh.so, and the build works OK now.

Re: ANNOUNCE: DBD:Oracle 1.18

2006-07-28 Thread John Scoles
- Original Message - From: Fox, Michael [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Thursday, July 27, 2006 11:00 PM Subject: RE: ANNOUNCE: DBD:Oracle 1.18 Sorry I did not get a chance to test this before the release, but I have had a couple of problems building the new version

Re: ANNOUNCE: DBD:Oracle 1.18

2006-07-28 Thread Martin J. Evans
On 28-Jul-2006 John Scoles wrote: - Original Message - From: Fox, Michael [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Thursday, July 27, 2006 11:00 PM Subject: RE: ANNOUNCE: DBD:Oracle 1.18 Sorry I did not get a chance to test this before the release, but I have had

RE: ANNOUNCE: DBD:Oracle 1.18

2006-07-27 Thread Fox, Michael
:42 AM To: dbi-users@perl.org; dbi-announce@perl.org; dbi-dev@perl.org Subject: ANNOUNCE: DBD:Oracle 1.18 DBD::Oracle 1.18 has been released. With this release DBD::Oracle finally implements Oracle's native Array Interface. You will see very dramatic increase in speed. For example; the time

RE: ANNOUNCE: DBD:Oracle 1.18

2006-07-25 Thread Steve Baldwin
-users@perl.org; dbi-announce@perl.org; dbi-dev@perl.org Subject: ANNOUNCE: DBD:Oracle 1.18 DBD::Oracle 1.18 has been released. With this release DBD::Oracle finally implements Oracle's native Array Interface. You will see very dramatic increase in speed. For example; the time for a 2

Re: ANNOUNCE: DBD:Oracle 1.18

2006-07-25 Thread John Scoles
@perl.org Sent: Tuesday, July 25, 2006 1:29 PM Subject: RE: ANNOUNCE: DBD:Oracle 1.18 John, When you say named parameter binding is not supported, are you talking about *all* named parameters, or just for array operations? We use named parameters (e.g. :cust_id) extensively because it is more

ANNOUNCE: DBD:Oracle 1.18

2006-07-24 Thread John Scoles
DBD::Oracle 1.18 has been released. With this release DBD::Oracle finally implements Oracle's native Array Interface. You will see very dramatic increase in speed. For example; the time for a 2 million plus insert query dropped from well over an hour to less than 10 minutes when using

DBD:Oracle

2006-04-11 Thread Maniace Libi - lmania
I have a developer who wants DBD::ORACLE installed on a Solaris server. There is not an instance of Oracle installed on this server. He is certain that it can be installed, but I can't find information supporting this. It always errors out with wanting Oracle_home. Is there a way to install DBD

Re: DBD:Oracle

2006-04-11 Thread John Scoles
You do not need an Oracle Database installed. However, you at least need an Oracle client installed on the same box. This is the Oracle_home that DBD:Oracle wants. Cheers John Scoles *** The information contained

Re: DBD:Oracle

2006-04-11 Thread Scott T. Hildreth
On Tue, 2006-04-11 at 11:09 -0500, Maniace Libi - lmania wrote: I have a developer who wants DBD::ORACLE installed on a Solaris server. There is not an instance of Oracle installed on this server. He is certain that it can be installed, but I can't find information supporting this. It

RE: DBD:ORACLE test failing

2005-09-13 Thread Reidy, Ron
: Tuesday, September 13, 2005 2:50 PM To: Reidy, Ron Cc: dbi-users@perl.org Subject: Re: DBD:ORACLE test failing Ron, Following is the output: Summary of my perl5 (revision 5 version 8 subversion 6) configuration: Platform: osname=solaris, osvers=2.9, archname=sun4-solaris uname='sunos

Re: DBD:ORACLE test failing

2005-09-13 Thread raja agireddy
compiler are yopu using. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: raja agireddy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 07, 2005 9:43 AM To: dbi-users@perl.org Subject: Fwd: DBD:ORACLE test failing -- Forwarded message

Fwd: DBD:ORACLE test failing

2005-09-08 Thread raja agireddy
-- Forwarded message -- From: raja agireddy [EMAIL PROTECTED] Date: Sep 7, 2005 11:28 AM Subject: DBD:ORACLE test failing To: modperl@perl.apache.org Hello! I have modepler2.0,Apache2.0.53 ,Perl5.8 on Sun OS 5.9. I have successfully installed DBI 1.48 and currently

RE: DBD:ORACLE test failing

2005-09-08 Thread Reidy, Ron
: DBD:ORACLE test failing -- Forwarded message -- From: raja agireddy [EMAIL PROTECTED] Date: Sep 7, 2005 11:28 AM Subject: DBD:ORACLE test failing To: modperl@perl.apache.org Hello! I have modepler2.0,Apache2.0.53 ,Perl5.8 on Sun OS 5.9. I have successfully installed DBI 1.48

A succesfull 64-bit build of Perl-DBI-DBD:Oracle on IBM AIX 5.2

2005-01-07 Thread Bjorn.Naessens
Hi, I finally succeeded in installing a 64bit build of Perl and its modules for Oracle 64-bit. We were running in 32bit but integrating Proc and cobols in our perl scripts only worked when we changed environments to 64bit causing problems for the oracle connections in perl. It's nothing

Re: DBD:ORACLE ... having trouble, need help fast!

2004-12-13 Thread Tim Bunce
On Sun, Dec 12, 2004 at 07:08:14PM -0500, Bryan Scott wrote: I am sort a Perl newbie. Does anyone know what I'm Doing wrong or what I'm missing? Don't try to build DBD::Oracle yourself. Download a pre-built one from http://ftp.esoftmatic.com/DBI Tim.

DBD:ORACLE ... having trouble, need help fast!

2004-12-12 Thread Bryan Scott
Been working on this for a few days haven't had any luck: I have read all of the help files searched the internet I still cannot find out what my problem is. I am running winxp pro (sp2), vis studio.net, oracle 9i (9.2.0.1) ActivePerl 5.8., jdk1.5.0 I also ran vcvars32.bat in vis

Re: Re[2]: DBD:Oracle (1.15 and 1.16 rc1) and xmltype()

2004-08-26 Thread Thomas Chiverton
On Wednesday 25 Aug 2004 21:48 pm, Wieland Pusch wrote: Or is it the point that you want to use xmltype(...). Well, I want DBD::Oracle to work with xmltype columns the same way it Just Works for all the other column types :-) I think atm DBD::Oracle passes the Perl string over to oracle as a

DBD:Oracle (1.15 and 1.16 rc1) and xmltype()

2004-08-23 Thread Thomas Chiverton
I am using the following: $sth = $dbh-prepare(insert into parsed_dtlogs (id,service_name,xml_doc) values ($item,'.$service_save.',xmltype(?))) or die Can't prepare SQL statement: $DBI::errstr\n; $sth-bind_param(1,$xml,ORA_CLOB); $sth-execute() or die Can't execute SQL statement: $DBI::errstr\n;

Re: DBD:Oracle (1.15 and 1.16 rc1) and xmltype()

2004-08-23 Thread Wieland Pusch
Hello Thomas, LOBs are defined to be possibly very large. So you should use ora_lob_write. You should to something like this: my $sth = $db-prepare( SQL ) or die insert $DBI::errstr; INSERT INTO clob ( id, txt ) VALUES ( ?, empty_clob() ) SQL $sth-execute( $lob_id ) or

Re: DBD:Oracle (1.15 and 1.16 rc1) and xmltype()

2004-08-23 Thread Thomas Chiverton
On Monday 23 Aug 2004 14:45 pm, Wieland Pusch wrote: LOBs are defined to be possibly very large. So you should use ora_lob_write. You should to something like this: It would be nice to have DBD/DBI just work though :-) In the end, I create an extra CLOB column, inserted into that, and then

Re: DBD:Oracle (1.15 and 1.16 rc1) and xmltype()

2004-08-23 Thread Tim Bunce
On Mon, Aug 23, 2004 at 04:07:52PM +0100, Thomas Chiverton wrote: On Monday 23 Aug 2004 14:45 pm, Wieland Pusch wrote: LOBs are defined to be possibly very large. So you should use ora_lob_write. You should to something like this: It would be nice to have DBD/DBI just work though :-)

Re: DBD:Oracle (1.15 and 1.16 rc1) and xmltype()

2004-08-23 Thread Thomas Chiverton
On Monday 23 Aug 2004 17:11 pm, you said: Send me a patch to t/31lob.t that tests the functionality you want and I'll try to sort it out for you. What would be the best way of including a large text string here ? Just inline would make it very messy... As far as I can see, there is no test for

Re: possible memory leak in either DBI or DBD:Oracle (or maybe oci??)

2004-03-30 Thread Roman Hochleitner
with leaking perl nocol monitors using DBI DBD:Oracle and I'm no perl expert, could anybody tell me how to debug this to find out exactly where it leaks and maybe prove that it is the oracle client itself so that I can make an official request to oracle to fix it? thanks in advice mfg Roman

(Fwd) Hello ... Regarding DBD:Oracle

2004-03-23 Thread Tim Bunce
- Forwarded message from Surjyendu Prakash [EMAIL PROTECTED] - Delivered-To: [EMAIL PROTECTED] X-Originating-IP: [209.220.7.247] X-Originating-Email: [EMAIL PROTECTED] From: Surjyendu Prakash [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Hello ... Regarding DBD:Oracle Date: Tue, 23 Mar

make procedure for DBD:Oracle not working

2004-03-15 Thread Neale Hirsh
Friends I installed DBI::Oracle and DBD::Oracle. The latter required modifying the Makefile.PL according to the correspondence of Tim et al in this mail-list, in late February. Essentially, one existing line of the makefile was changed and one new line was added. Then the perl Makefile.PL

RE: DBD:Oracle perl Makefile.PL problem

2004-02-26 Thread Howell, Andrew
Yes. This also works. Andrew -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: February 25, 2004 5:21 PM To: Howell, Andrew Cc: 'Tim Bunce'; '[EMAIL PROTECTED]' Subject: Re: DBD:Oracle perl Makefile.PL problem On Wed, Feb 25, 2004 at 04:29:06PM -0500, Howell, Andrew

DBD:Oracle perl Makefile.PL problem

2004-02-25 Thread Howell, Andrew
While trying to get the make test for DBD:ORACLE to work, I noticed the problem below. Note 1: I still haven't resolved the make test problem. I'm getting a symbol OCILobWriteAppend: referenced symbol not found error. Since other people have reported this problem, I won't bother you

Re: DBD:Oracle perl Makefile.PL problem

2004-02-25 Thread Tim Bunce
On Wed, Feb 25, 2004 at 12:49:34PM -0500, Howell, Andrew wrote: make -f /usr2/opt2/app/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o echo echo

Re: DBD:Oracle perl Makefile.PL problem

2004-02-25 Thread Tim Bunce
On Wed, Feb 25, 2004 at 12:49:34PM -0500, Howell, Andrew wrote: make -f /usr2/opt2/app/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o echo echo

RE: DBD:Oracle perl Makefile.PL problem

2004-02-25 Thread Howell, Andrew
PROTECTED]' Subject: Re: DBD:Oracle perl Makefile.PL problem On Wed, Feb 25, 2004 at 12:49:34PM -0500, Howell, Andrew wrote: make -f /usr2/opt2/app/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE

Re: DBD:Oracle perl Makefile.PL problem

2004-02-25 Thread Tim Bunce
On Wed, Feb 25, 2004 at 04:29:06PM -0500, Howell, Andrew wrote: Changing cc=echo to cc= seems to have fixed the problem. Applying the changes below in a separate also run seemed to fixed the problem. Actually that wasn't a good fix. Here's what I've adopted now: --- Makefile.PL (revision

Re: Building Perl 64-bit with DBI and DBD:ORACLE 9i on AIX 5L

2004-02-23 Thread Tim Bunce
: [EMAIL PROTECTED] Subject: Re: Building Perl 64-bit with DBI and DBD:ORACLE 9i on AIX 5L On Fri, Feb 20, 2004 at 02:22:03PM +0100, [EMAIL PROTECTED] wrote: However at the moment we upgraded our C compiler to compile completely in 64-bit and the environment can not include the lib32's

RE: Building Perl 64-bit with DBI and DBD:ORACLE 9i on AIX 5L

2004-02-22 Thread Bjorn.Naessens
- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: vrijdag 20 februari 2004 16:39 To: Bjorn Naessens Cc: [EMAIL PROTECTED] Subject: Re: Building Perl 64-bit with DBI and DBD:ORACLE 9i on AIX 5L On Fri, Feb 20, 2004 at 02:22:03PM +0100, [EMAIL PROTECTED] wrote: However at the moment we upgraded

Building Perl 64-bit with DBI and DBD:ORACLE 9i on AIX 5L

2004-02-20 Thread Bjorn.Naessens
Hi guys, I got perl, DBI and DBD:Oracle working on my AIX machine with some help of you guys, but that was some months ago with the 32-bit build of perl and all lib32 libraries of Oracle. However at the moment we upgraded our C compiler to compile completely in 64-bit and the environment

Re: Building Perl 64-bit with DBI and DBD:ORACLE 9i on AIX 5L

2004-02-20 Thread Tim Bunce
anymore without including lib32 before the lib but then C's are not working anymore and ... A neverending loop here :-) I was thinking that maybe there is a possibility now to compile perl in a full 64-bit mode and still get the database access with DBI and DBD:oracle in 64-bit. Get perl

Re: Followup: 20040131-- DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-02-01 Thread Tim Bunce
On Sat, Jan 31, 2004 at 08:30:51PM -0500, Gerard Tromp wrote: Some additional data. When the tests are trimmed to 13 (see previous message below), the failure affects only 2 (9,11) or 3 (9,11,12) tests. The tests are: 9 ok(0, $tmp = $sth-fetchall_arrayref, 1); # line 156 11ok(0,

Followup: 20040131-- DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-02-01 Thread Gerard Tromp
:59 To: Tim Bunce Cc: [EMAIL PROTECTED] Subject: RE: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7) Hello Tim, others, I pared down the tests as per the suggestion (push @tests) and reduced the tests to 13 by commenting out the remaining 80 tests in the [LONG, 0, 0] set

Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-30 Thread Tim Bunce
On Thu, Jan 29, 2004 at 02:07:49PM -0600, Scott T. Hildreth wrote: I'm trying to build on OSF, Perl 5.6.1, and Oracle 8.1.7. 1.14 builds(make test), but 1.15 prints this error on first test, t/base...Failed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed:

Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-30 Thread Scott T. Hildreth
build log is attached, looks like libclntsh is linked in. On Fri, 2004-01-30 at 04:22, Tim Bunce wrote: On Thu, Jan 29, 2004 at 02:07:49PM -0600, Scott T. Hildreth wrote: I'm trying to build on OSF, Perl 5.6.1, and Oracle 8.1.7. 1.14 builds(make test), but 1.15 prints this error on first

Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-30 Thread Tim Bunce
On Fri, Jan 30, 2004 at 09:20:00AM -0600, Scott T. Hildreth wrote: Oracle oci build command: [-L/u01/app/oracle/product/8.1.7/lib/ -L/u01/app/oracle/product/8.1.7/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh -lc] I wish they were all that simple...

RE: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-30 Thread Gerard Tromp
everyone posted. Gerard -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 13:36 To: Gerard Tromp Cc: [EMAIL PROTECTED] Subject: Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7) On Wed, Jan 28, 2004 at 08:56:51PM -0500

DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-29 Thread Gerard Tromp
DBD::Oracle 1.15 fails for tests 195, 196, 197 and 198 Note that DBD::Oracle 1.14 is OK (somehwat fewer tests, so perhaps the bug isn't triggered -- I have not yet delved into the differrences between the test sets). The failure is peculiar. Oracle complains about the date format being wrong,

Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-29 Thread Tim Bunce
On Wed, Jan 28, 2004 at 08:56:51PM -0500, Gerard Tromp wrote: DBD::Oracle 1.15 fails for tests 195, 196, 197 and 198 Oracle version 8.1.7.0.0 for both server and client. If there's anyone out there using Oracle 8.1.x could you please test DBD::Oracle 1.15 and let us know if it works or not

Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-29 Thread Scott T. Hildreth
I'm trying to build on OSF, Perl 5.6.1, and Oracle 8.1.7. 1.14 builds(make test), but 1.15 prints this error on first test, t/base...Failed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:

Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-29 Thread Scott T. Hildreth
..tried Makefile.PL -nob, but I got different error. It couldn't find upeiosomething like that. Here is the some output from 'perl Makefile.PL -s OCILobWriteAppend', searching oracle lib/libclient8.a ... OCILobWriteAppend| 4064 | T | 0008

RE: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

2004-01-29 Thread KIDDER, ERIC J (SBCSI)
-Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:36 PM [snip] If there's anyone out there using Oracle 8.1.x could you please test DBD::Oracle 1.15 and let us know if it works or not for you? It works fine if I do 'perl Makefile.PL

RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-20 Thread Andrews, Mark
10:37 AM To: 'Paul Clements'; [EMAIL PROTECTED] Subject: RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808 It sounds like you were running the older .dll from the newer perl. Are you sure you: a) Didn't have the Oracle.dll loaded so that ppm failed to overwrite

RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-20 Thread Jeff Urlwin
... Regards, Jeff -Original Message- From: Andrews, Mark [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 8:45 AM To: [EMAIL PROTECTED] Subject: RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808 I encountered a very similar problem to this on a Windows XP

Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-16 Thread Paul Clements
Hi, I have just downloaded 5.8.2 Build 808 from ActiveState and the 5.8.2 branch of DBI and DBD:Oracle from ftp.esoftmatic.com/outgoing/DBI/5.8.2 Unfortunately I get the error The procedure entry point Perl_Glockhook_ptr could not be located in the dynamic link library perl58.dll From

RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-16 Thread Jeff Urlwin
Hi, I have just downloaded 5.8.2 Build 808 from ActiveState and the 5.8.2 branch of DBI and DBD:Oracle from ftp.esoftmatic.com/outgoing/DBI/5.8.2 Unfortunately I get the error The procedure entry point Perl_Glockhook_ptr could not be located in the dynamic link library perl58.dll

RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-16 Thread Paul Clements
To: Paul Clements; [EMAIL PROTECTED] Cc: Subject: RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808 Hi, I have just downloaded 5.8.2 Build 808 from ActiveState and the 5.8.2 branch of DBI and DBD:Oracle from

RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808

2004-01-16 Thread Jeff Urlwin
To: Jeff Urlwin; [EMAIL PROTECTED] Subject: RE: Binary releases for DBI and DBD:Oracle for ActivePerl Build 808 Jeff, Thanks for getting back to me as requested I have appended the results of perl -v are This is perl, v5.8.2 built for MSWin32-x86-multi-thread

  1   2   3   >