Re: Segfault with large clobs on Oracle

2004-01-09 Thread Tim Bunce
Nevermind. That's now a "can't refetch lob from that kind of statement" error. DBD::Oracle 1.15 has a new way of dealing with LOB locators directly. Tim. On Fri, Jan 09, 2004 at 11:07:56PM +, Tim Bunce wrote: > Can you, or someone, send me a test case that (ideally) doesn't > include a funct

Re: Segfault with large clobs on Oracle

2004-01-09 Thread Tim Bunce
Can you, or someone, send me a test case that (ideally) doesn't include a function call to your own code but just uses PL/SQL LOB functions? If I get that soon I'll try to fix it for the 1.15 release or at least the 1.16 release. Tim. On Fri, May 02, 2003 at 10:03:23AM +0100, Chris Underhill wro

Re: Possible memory corruption bug in DBD::Oracle

2004-01-09 Thread Tim Bunce
I reproduced it on Oracle 9.0.1. It's now fixed in the next release, which I'm actively working on now. At last. Tim. On Fri, Oct 17, 2003 at 08:36:09AM +1000, Steve Baldwin wrote: > I'm not sure whether this is a DBD::Oracle bug or a bug in the Oracle > client libs, but it only seems to manifest

RE: fetching statement attribute NAME causes query to be executed again

2004-01-09 Thread Jeff Urlwin
> > > Hi Jeff, > > > > Will that still cause the query to be executed twice though? > > > My concern is that this is a generic sql wrapper, and while > > > the alter table query is safe to wrap in an eval, running > > > other queries twice silently might have nasty side effects. > > > > Sorry

Re: Perl and DBI (and either DBD::ODBC or DBD::Informix)

2004-01-09 Thread Jonathan Leffler
BAFFIGI, Christian wrote: I want to generate a connection to Informix Database with Perl through DBI. Can anybody tell me, which steps I need to follow to install PERL and DBI? As others have already established that you're using Win2K, you have a couple of options. The easier is to use DBD::ODB

Re: fetching statement attribute NAME causes query to be executed again

2004-01-09 Thread Alex Krohn
Hi Jeff, > > Will that still cause the query to be executed twice though? > > My concern is that this is a generic sql wrapper, and while > > the alter table query is safe to wrap in an eval, running > > other queries twice silently might have nasty side effects. > > Sorry -- I forgot to answe

RE: fetching statement attribute NAME causes query to be executed again

2004-01-09 Thread Jeff Urlwin
> > Hi Jeff, > > > No, but I may be able to make NUM_OF_FIELDS and NAME return > undef, but > > that may hide other issues, so I'd suggest wrapping it in > an "eval". > > I.E. > > > > $sth->prepare($sql); > > $sth->execute; > > eval { > > $foo = $sth->{NUM_OF_FIELDS}; > > }; > > > > if

$dbh->column_info question

2004-01-09 Thread David Kuo
Hi there, Can anyone guides me why $dbh->column_info is not working for me? ActivePerl v5.6.1 built for MSWin32-x86-multi-thread Win2K DBI 1.37 DBD-Oracle 1.12 DBD-Oracle8 1.06 It just returns undef without any error. Below is the trace info with trace level 3. DBI 1.37-ithread dispatch tra

RE: Binary build(s) of DBI, DBD::ODBC and DBD::Oracle available for ActivePerl 807

2004-01-09 Thread Yaakov Sash
Jeff, After I downloaded it locally, I was able to install it. It wasn't a proxy issue. I think the reason it wasn't working directly from the ftp site, is because the browser thinks the "ppd" files are HTML, not binary. When I downloaded the pdd files locally, I had to be careful to download th

RE: :Oracle at "make test" stage: Failed to load Oracle extension and/or shared libraries

2004-01-09 Thread Mohammed Maati
Hi, I did build my own perl following the instructions in README.hpux and I got blocked exactly at the same spot as before with exactly the same error message. Thanks for the help. Mohammed Amin Maati Unix Systems Administrator Information Technology - Global Technology Services BiogenIdec Tel

RE: t/40profile Failed test 20

2004-01-09 Thread David Mann
You hit the nail right on the head. SMP configuration cause of issue. Thanks for your insight, David. -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 5:32 AM To: David Mann Cc: '[EMAIL PROTECTED]' Subject: Re: t/40profile Failed test 20 On

Re: DBI 1.4 make test problems

2004-01-09 Thread Michael Peppler
Ok - this is almost certainly a problem with LANG and/or LC_ALL. See http://www.mbay.net/~mpeppler/Linux-ASE-FAQ.html#q1.14 Michael On Fri, 2004-01-09 at 08:37, [EMAIL PROTECTED] wrote: > thanx! > > You need the backtrace? > > > (gdb) bt > #0 0x42049caf in buffered_vfprintf () from /lib/tls/

Re: fetching statement attribute NAME causes query to be executed again

2004-01-09 Thread Alex Krohn
Hi Jeff, > No, but I may be able to make NUM_OF_FIELDS and NAME return undef, but that > may hide other issues, so I'd suggest wrapping it in an "eval". I.E. > > $sth->prepare($sql); > $sth->execute; > eval { > $foo = $sth->{NUM_OF_FIELDS}; > }; > > if ($@) { > # num of fields failed..

RE: Binary build(s) of DBI, DBD::ODBC and DBD::Oracle available for ActivePerl 807

2004-01-09 Thread Jeff Urlwin
> > Jeff, > > After I downloaded it locally, I was able to install > it. > > It wasn't a proxy issue. I think the reason it wasn't > working directly from the ftp site, is because the > browser thinks the "ppd" files are HTML, not binary. > When I downloaded the pdd files locally, I had to be >

RE: fetching statement attribute NAME causes query to be executed again

2004-01-09 Thread Jeff Urlwin
> > Hi, > > > It's certainly a DBD::ODBC bug. > > > > > Any ideas on workarounds? > > > > Don't access NAME, or similar attributes, unless > $sth->{NUM_OF_FIELDS} > > is true. > > Thanks for the suggestion! Unfortunately, it seems accessing > NUM_OF_FIELDS also triggers the query to be execu

Re: fetching statement attribute NAME causes query to be executed again

2004-01-09 Thread Alex Krohn
Hi, > It's certainly a DBD::ODBC bug. > > > Any ideas on workarounds? > > Don't access NAME, or similar attributes, unless $sth->{NUM_OF_FIELDS} > is true. Thanks for the suggestion! Unfortunately, it seems accessing NUM_OF_FIELDS also triggers the query to be executed again: Describe failed

RE: Binary build(s) of DBI, DBD::ODBC and DBD::Oracle available for ActivePerl 807

2004-01-09 Thread Yaakov Sash
Jeff, After I downloaded it locally, I was able to install it. It wasn't a proxy issue. I think the reason it wasn't working directly from the ftp site, is because the browser thinks the "ppd" files are HTML, not binary. When I downloaded the pdd files locally, I had to be careful to download th

Re: DBI 1.4 make test problems

2004-01-09 Thread Michael Peppler
On Fri, 2004-01-09 at 06:45, [EMAIL PROTECTED] wrote: > from the /tmp/dbitrace.log > > > > <- install_driver= DBI::dr=HASH(0x82317ac) > -> DBI->install_driver(Sponge) for linux perl=5.008 pid=6841 ruid=0 euid=0 >install_driver: DBD::Sponge version 11.10 loaded from > /root/.cpan/bu

DBD-Oracle-1.14

2004-01-09 Thread letizia . mazzurco
Hi support, I have any problem installing DBD-Oracle-1.14. The command 'perl Makefile.PL' on OK : # Using DBI 1.39 installed in /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI Configuring DBD::Oracle ... >>>

Re: DBI 1.4 make test problems

2004-01-09 Thread kmart
Hi tim, > > ok 39 at line 107 > dubious > Test returned status 0 (wstat 11, 0xb) > DIED. FAILED tests 40-43 > > Tests 40-43 test DBI->installed_versions(). I'd guess that you have > a driver that kills the process when it's loaded. > > In the DBI source director

Re: DBI 1.4 make test problems

2004-01-09 Thread Tim Bunce
On Fri, Jan 09, 2004 at 09:45:13AM -0500, [EMAIL PROTECTED] wrote: > Hi tim, > > I guess it should have been: > > [EMAIL PROTECTED] DBI-1.40]# perl -MDBI -e 'DBI->installed_versions' > Segmentation fault Yeap. Thanks. > > Also try > > DBI_TRACE=4=/tmp/dbitrace.log perl -Mblib t/01basics.t >

RE: Perl and DBI

2004-01-09 Thread David Mann
Check the DBD::Informix module on CPAN. You need the Informix client SDK for your platform installed so start there as it takes some patience to get up and going. David Mann -Original Message- From: BAFFIGI, Christian [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 7:19 AM To

Re: New dbi.perl.org - and help purging links to old DBI sites

2004-01-09 Thread Tim Bunce
I'm happy to report that dbi.perl.org is now the top result on google for "DBI". Many thanks to all who have helped. As an extra bonus, google now adds: Category: Computers > Programming > Languages > Perl > Database http://directory.google.com/Top/Computers/Programming/Languages/Perl/Database/

RE: Perl and DBI

2004-01-09 Thread Hardy Merrill
David has a point - you should at least _try_ to find some information before you ask a question. Are you a newbie to Perl and DBI both? You should start with the ActiveState site (www.activestate.com) - there you'll find ActivePerl. ActivePerl comes with a nice utility called ppm that allows yo

RE: Perl and DBI

2004-01-09 Thread David N Murray
I'm kind of curious. If you aren't willing to use google to do the 30 seconds of searches needed to find ActiveState and ppm to install perl, how are you going to write a program in perl using DBI? Maybe you should start here: http://www.catb.org/~esr/faqs/smart-questions.html On Jan 9, BAFFIGI,

RE: Perl and DBI

2004-01-09 Thread BAFFIGI, Christian
I run perl on W2k. Database resides on UNIX -Mensaje original- De: Hardy Merrill [mailto:[EMAIL PROTECTED] Enviado el: Friday, January 09, 2004 10:36 AM Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: Re: Perl and DBI What OS are you on? >>> "BAFFIGI, Christian" <[EMAIL PROTECTED]> 0

Re: Perl and DBI

2004-01-09 Thread Hardy Merrill
What OS are you on? >>> "BAFFIGI, Christian" <[EMAIL PROTECTED]> 01/09/04 07:19AM >>> I want to generate a connection to Informix Database with Perl through DBI. Can anybody tell me, which steps I need to follow to install PERL and DBI? Thanks in advance

Perl and DBI

2004-01-09 Thread BAFFIGI, Christian
I want to generate a connection to Informix Database with Perl through DBI. Can anybody tell me, which steps I need to follow to install PERL and DBI? Thanks in advance = WARNING The information in t

Re: DBI 1.4 make test problems

2004-01-09 Thread Tim Bunce
On Thu, Jan 08, 2004 at 04:53:27PM -0500, [EMAIL PROTECTED] wrote: > Hi, > > I am unable to pass all the test. I am not my installation is OK. > > System: Linux 2.4.20-20.9 > Perl: v5.8.0 built for i386-linux-thread-multi > > attached is the output of a 'make test TEST_VERBOSE=1'. > > Anyone h

Re: t/40profile Failed test 20

2004-01-09 Thread Tim Bunce
On Thu, Jan 08, 2004 at 04:53:30PM -0500, David Mann wrote: > > I see some chatter about this failure but have yet to resolve it, any > takers. > > Here's the snippet from "perl -Mblib t/40profile.t" > > ok 19 > not ok 20 > # Failed test 20 in t/40profile.t at line 93 > profile data: [1951 0

Re: fetching statement attribute NAME causes query to be executed again

2004-01-09 Thread Tim Bunce
On Thu, Jan 08, 2004 at 10:14:59AM -0800, Alex Krohn wrote: > Hi, > > The following script: > > use DBI; > DBI->trace(3, "trace.log"); > my $dbh = DBI->connect('DBI:ODBC:testdb', 'sa', ''); > my $sth = $dbh->prepare("create table foo (a int)"); > $sth->execute; > $sth = $dbh->prepare("alter table

DBI 1.4 make test problems

2004-01-09 Thread kmart
Hi, I am unable to pass all the test. I am not my installation is OK. System: Linux 2.4.20-20.9 Perl: v5.8.0 built for i386-linux-thread-multi attached is the output of a 'make test TEST_VERBOSE=1'. Anyone have a clue? Regards, Martin Gingras Ing. make_test.out Description: Binary data

Fw: DBD-Oracle-1.14

2004-01-09 Thread Scheper, Clemens
Hello, to prevent OCIEnvInit error message, environment variable ORA_NLS33 must point to the old ORACLE version ($ORACLE_BASE/817/ocommon/nls/admin/data). I cannot install DBD-Oracle-1.14 in our ora9i environment, because this is in 64 bit. During "make" I get message ld: /.../libclntsh.so: wr