Building DBD::Oracle on OS/X Leopard

2009-04-01 Thread Steve Baldwin
I'm attempting to build DBD::Oracle for the first time on a Mac. Not much luck so far. I'm attempting to build using the latest Instant Client. Here's what happens ... stbaldwins-macbook-pro:DBD-Oracle-1.22-DQ1QKH root# perl Makefile.PL Using DBI 1.52 (for perl 5.008008 on darwin-thread-m

Re: 5.8.9 eating up memory with AUTOLOAD in DBD::Oracle

2009-04-01 Thread Scott T. Hildreth
On Wed, 2009-04-01 at 12:54 -0500, Scott T. Hildreth wrote: > Wanted to change the subject. > > > On Wed, 2009-04-01 at 11:11 -0500, Scott T. Hildreth wrote: > > Hello, > > > > I'm having a strange problem. I compiled 5.8.9 on SUSE Linux > > Enterprise Server 10 (x86_64), > > installed D

Re: 5.8.9 eating up memory with AUTOLOAD in DBD::Oracle

2009-04-01 Thread Scott T. Hildreth
Wanted to change the subject. On Wed, 2009-04-01 at 11:11 -0500, Scott T. Hildreth wrote: > Hello, > > I'm having a strange problem. I compiled 5.8.9 on SUSE Linux Enterprise > Server 10 (x86_64), > installed DBI & DBD::Oracle. We are running Oracle 11g on this server. > Running a pr

Re: DBD::Oracle problem with bind_param_inout and UTF-8

2009-04-01 Thread Steve Baldwin
Hi John, Did you make any sense of this? Thanks, Steve On 30/03/2009, at 10:39 AM, Steve Baldwin wrote: John, In case it helps, here is a version of my test script that seems to correctly handle utf-8 chars for bind_param_inout ... #!/usr/bin/perl -w use strict; use warnings; use DBI qw()

5.8.9 eating up memory with AUTOLOAD

2009-04-01 Thread Scott T. Hildreth
Hello, I'm having a strange problem. I compiled 5.8.9 on SUSE Linux Enterprise Server 10 (x86_64), installed DBI & DBD::Oracle. We are running Oracle 11g on this server. Running a program that uses DBI/DBD::Oracle, the process locked the server up by using all the memory and swap. The

Re: Oracle VARRAY support

2009-04-01 Thread John Scoles
Actually it does support varray types since 1.20 (at least for select) http://search.cpan.org/~pythian/DBD-Oracle-1.22/Oracle.pm#Object_&_Collection_Data_Types You can select them all you want. I have not yet added support for inserts and updates and that is handled by psql better than the hay

Oracle VARRAY support

2009-04-01 Thread Udo Grabowski
Still dbi::Oracle does not support Oracle varray types. Any plans to implement this ? Or does anybody know another perl connector module that supports this type ? We still only can use the java jdbc connectors which have support for that odd speciality. -- Dr. Udo Grabowski

[Fwd: [ANNOUNCE] == Postgres Weekly News - April 01 2009 ==]

2009-04-01 Thread Darren Duncan
This is not Perl specific, but probably something any current or possible users of Postgres should know as they plan their futures. -- Darren Duncan Original Message Subject: [ANNOUNCE] == Postgres Weekly News - April 01 2009 == Date: Wed, 1 Apr 2009 01:44:32 -0700 From: David

RE: Problem with Oracle ODBC connection

2009-04-01 Thread Oeschey, Lars (I/ET-83, extern)
> All we can say now is that you successfully issue a query on > a table and > it returns now rows. ok, I have to apologize for my dumbness and stealing your time... I'm not used to oracle and to have to commit... With the PostgreSQL's I usually work with we have Autocommit running, but not on t

RE: Problem with Oracle ODBC connection

2009-04-01 Thread Oeschey, Lars (I/ET-83, extern)
> If sqlplus DOES return data: > What version of Oracle ODBC and Oracle client are you using, > and what > version is oracle on the far end? hm, how can I find out the client version? I see nothing in the ODBC connection about the version, but when I click the Help Button, I get the help for ve