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

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

[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

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

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

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: 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

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 program

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 DBI

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