RE: Problem with closing bound cursors

2003-12-01 Thread Fox, Michael
Dave, Not real sure; you seem to have done it as per the examples in the doco ( I just use bind_param for the close cursor, not bind_param_inout. And I use it with a stored procedure, as in: $sql = "BEGIN dwh_util.ref_cursor_close(:curref); END;"; $sth = $dbh->prepare($sql); $st

Re: Problem with closing bound cursors

2003-12-01 Thread Andy Hassall
Dave Bloom wrote: > > I have been trying to close bound cursors for a week now > and am completely at a loss. No matter what I do I get: > > > DBD::Oracle::st execute failed: ORA-01001: invalid cursor > > ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) at /tmp/test line > 36. > > I've followed

Re: DBD::Pg 1.31 under mod_perl

2003-12-01 Thread Rudy Lippan
On Mon, 1 Dec 2003, Ask Solem Hoel wrote: > Anyone got this working under mod_perl yet? > > Just upgraded DBI from 1.32 to 1.39 and DBD::Pg from 1.22 to 1.31, > and Apache/mod_perl suddently dies without any trace of error in > the logs. Try this: pandora:~/Projects/dbdpg/head/dbdpg:$ cvs diff

Re: Perl DBI and oracle 9/10

2003-12-01 Thread Tim Bunce
On Mon, Dec 01, 2003 at 03:58:05PM -, Martin Widlake wrote: > Hi, > > This is an enquiry about perl-DBI support for oracle 9 and 10. > > We use oracle 9 (and 8) and have perl-DBI working against those versions > of Oracle fine. However, we are beta testing Oracle 10 and I wondered if > anyon

fetching data from an array variable

2003-12-01 Thread J Greenbaum
Hello, I'm using Postgres 7.4, DBI 1.39, DBD:Pg 1.31, and Perl 5.80 on a RH Linux 9 machine. I am trying to retrieve data from an array variable in one of my tables, but keep getting a segmentation fault. The prepare and execute statements work fine, but when I try to fetch them via any of t

Re: upgrading to modperl2 & apache2 DBI 1.38

2003-12-01 Thread Tim Bunce
On Mon, Dec 01, 2003 at 11:14:16AM +0200, Afgin Shlomit wrote: > I install Apache 2.0.48 and modperl 1.99_10 I moved scripts that run okay > before with older versions. When I run my script I get the error: > an't use string ("") as a HASH ref while "strict refs" in use at > /usr/local/lib/perl5/si

DBD::Pg 1.31 under mod_perl

2003-12-01 Thread Ask Solem Hoel
On Wed, 2003-11-19 at 18:01, Rudy Lippan wrote: > DBD::Pg 1.31 is out and on CPAN. > Anyone got this working under mod_perl yet? Just upgraded DBI from 1.32 to 1.39 and DBD::Pg from 1.22 to 1.31, and Apache/mod_perl suddently dies without any trace of error in the logs. Programs not running und

Re: Problem installing Bundle::DBD::mysql

2003-12-01 Thread Rudy Lippan
On Sat, 29 Nov 2003, Lance Cottrell wrote: > I did the install using perl -MCPAN -e 'install Bundle::DBD::mysql' > > Everything looks like it is going fine until the very end when I see: > > > LD_RUN_PATH="/usr/local/mysql/lib/mysql:/usr/lib" /usr/bin/perl myld > > MACOSX_DEPLOYMENT_TARGET=10.3

Oracle Spatial

2003-12-01 Thread Mike Schienle
Hi all - Is there anything different that needs to be done to work with the Oracle Spatial database using DBI? Is there a different DBD::Oracle driver or something along those lines for Oracle Spatial? I've worked with DBI and DBD::Oracle in the past, but just with standard Oracle. Mike Schien

Perl DBI and oracle 9/10

2003-12-01 Thread Martin Widlake
Hi, This is an enquiry about perl-DBI support for oracle 9 and 10. We use oracle 9 (and 8) and have perl-DBI working against those versions of Oracle fine. However, we are beta testing Oracle 10 and I wondered if anyone had looked at perl-DBI working against 10 yet. We use perl against our Oracl

Problem with closing bound cursors

2003-12-01 Thread Dave Bloom
Folks, I have been trying to close bound cursors for a week now and am completely at a loss. No matter what I do I get: > DBD::Oracle::st execute failed: ORA-01001: invalid cursor > ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) at /tmp/test line 36. I've followed the documentation listed in CP

Suggestion for enhancement of DBD::ODBC

2003-12-01 Thread Martin Busik
Hi, I think it would be helpful to pass the NativeError as third parameter to odbc_err_handler. AFAIK this variable contains the numerical representation of a error/warning, so it is more suitable for further processing than regex matching againt the error string. patch to the dbdimp.c file is the

upgrading to modperl2 & apache2 DBI 1.38

2003-12-01 Thread Afgin Shlomit
I install Apache 2.0.48 and modperl 1.99_10 I moved scripts that run okay before with older versions. When I run my script I get the error: an't use string ("") as a HASH ref while "strict refs" in use at /usr/local/lib/perl5/site_perl/5.8.1/sun4-solaris/DBI.pm line 509 What can be the problem?

ANNOUNCE: DBD::ADO 2.81

2003-12-01 Thread Steffen Goeldner
file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.81.tar.gz size: 45171 bytes md5: e0f78cbdeea4ffe3fb7657131bcbebad Changes: Fixed Makefile.PL to work with strict 1.03 (perl 5.8.1.), reported by Eric Thinnes. Added ping(). Added tests for ping() to t/02cxn.t. Removed ping() tests