Re: Topic Changes _Really_ Needs a New Subject

2002-02-08 Thread BAO RuiXian
Thanks Mac for changing the subject line. I thought it is natural to give more experience/problems with the thread of child/parent discussion (databases are different, of course), but it seems that is not a suitable way to raise problems. Bao Michael A Chase wrote: You are not doing yourself

DBD::ODBC 0.34 - dependency on Perl 5.0 patchlevel 6 subversion 1?

2002-02-08 Thread martin
Just installed DBD::ODCB 0.34 on my test machine and got this: [martin@brimer DBD-ODBC-0.34]$ make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;'

Re: Perl DBI-connect

2002-02-08 Thread Bart Lateur
On Thu, 7 Feb 2002 21:36:40 -0800, Michael A Chase wrote: On Thu, 7 Feb 2002 12:14:02 -0800, Michael A Chase wrote: # You don't need to disconnect, each assignment to $dbh does that for you. If only with a warning. You get a warning if you let the program exit without disconnecting.

RE: :ODBC 0.34 - dependency on Perl 5.0 patchlevel 6 subversion 1?

2002-02-08 Thread Jeff Urlwin
Martin, That line sounds familiar :) I put in the no warnings to turn off the warning that I was using an uninitialized value. Yes, I wanted to pass undef to the bind param, but the warning stunk. Go ahead and take that line out and let me know how it works for you. Thanks, Jeff

Problems compiling DBD::Pg...

2002-02-08 Thread Johan Mjönes
Hello, I'm having troubles compiling DBD-Pg v1.01 under Red Hat 6.2. I'm using Postgres 7.2, which is compiled with --enable-locale and installed under /usr/local/pgsql [root@fetburk DBD-Pg-1.01]# set POSTGRES_INCLUDE=/usr/local/pgsql/include POSTGRES_LIB=/usr/local/pgsql/lib/libpq.so

Problems installing DBD module in HP-UX 11.0

2002-02-08 Thread Montserrat_Cabero
Hi, First of all, excuse my grammar mistakes, because I'm spanish and I seldom write in English. We are trying to install DBD and DBI modules in HP-UX 11.0 Model: 9000/800/A440-44. Main Memory: 1024 MB Processors:1 and we have a lot of problems. ¿Is there an special module for HP-UX? Because

RE: :ODBC 0.34 - dependency on Perl 5.0 patchlevel 6 subversion

2002-02-08 Thread martin
On 08-Feb-2002 Jeff Urlwin wrote: Martin, That line sounds familiar :) I put in the no warnings to turn off the warning that I was using an uninitialized value. Yes, I wanted to pass undef to the bind param, but the warning stunk. Go ahead and take that line out and let me know how

Re: Problems compiling DBD::Pg...

2002-02-08 Thread Philip Molter
On Fri, Feb 08, 2002 at 02:04:40PM +0100, Johan Mjönes wrote: : : Hello, : : I'm having troubles compiling DBD-Pg v1.01 under Red Hat 6.2. : : I'm using Postgres 7.2, which is compiled with --enable-locale and installed : under /usr/local/pgsql : : [root@fetburk DBD-Pg-1.01]# set : :

RE: Perl DBI-connect

2002-02-08 Thread Khamneian, Mahtaj
Thanks. I've taken the disconnect line out. I am still getting the Segmentation Fault when the userid/password is correct. What is interesting is that this generates an oracle core dump (in the instance's dump directory) and when I try the script with only one set of correct userid/password,

Re: DBD-Oracle-1.12 for HP-UX 11 (B.11.00 U 9000/800) - Problem bui lding

2002-02-08 Thread Tim Bunce
On Fri, Feb 08, 2002 at 04:23:40PM +1100, Szeto, Kent wrote: Dear Dbi-users, I am having trouble building the above DBD and I have NOT a clue what the error messages are telling me. Can't shl_load() a library containing Thread Local Storage: It's telling you to read the README file and

Re: Embedding perl in Oracle

2002-02-08 Thread Scott T. Hildreth
Tim, Will you be posting the this talk any time soon? On 27-Dec-01 Tim Bunce wrote: I'm putting together a Using Perl with Oracle talk (for the Perl Whirl '02 GeekCruise conference) and would very much like to hear from anyone who's used Jeff's extproc_perl. The talk, like all my

Installing DBI 1.21 - Undefined subroutine Test::Harness::WCOREDUMP

2002-02-08 Thread Gustavo Delfino
I'm trying to move from DBI 1.14 to 1.21 but I get an error when testing. I'm using perl version 5.005_03 built for i386-linux. Any advice? Regards, Gustavo Delfino Caracas, Venezuela cpan r DBI Package namespace installedlatest in CPAN file DBI1.14

Re: Installing DBI 1.21 - Undefined subroutine Test::Harness::WCOREDUMP

2002-02-08 Thread Gustavo Delfino
On 2/8/02 at 11:36 AM, [EMAIL PROTECTED] (Gustavo Delfino) wrote: I'm trying to move from DBI 1.14 to 1.21 but I get an error when testing. I'm using perl version 5.005_03 built for i386-linux. Any advice? I found the problem, I had to install Devel::Peek first. Shouldn't CPAN tell you

RE: :ODBC 0.34 - dependency on Perl 5.0 patchlevel 6 subversion

2002-02-08 Thread Jeff Urlwin
Martin, Do you get any warnings when you run it? I found them annoying, but I will comment out the no warnings... Thanks, Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 08, 2002 8:17 AM To: [EMAIL

Re: Embedding perl in Oracle

2002-02-08 Thread Scott T. Hildreth
Got the Pause message, thanks Tim. STH On 08-Feb-02 Scott T. Hildreth wrote: Tim, Will you be posting the this talk any time soon? On 27-Dec-01 Tim Bunce wrote: I'm putting together a Using Perl with Oracle talk (for the Perl Whirl '02 GeekCruise

Re: Embedding perl in Oracl

2002-02-08 Thread Scott T. Hildreth
On Fri, Feb 08, 2002 at 12:25:45PM -0500, Richard A. Nakroshis wrote: yes is does, but you can get it at, ftp://pause.perl.org/pub/PAUSE/authors/id/TIMB/ Scott, I saw your message and Pause message too, but wasn't able to find it on cpan.org. Does it take a while to appear? Thanks,

RE: :ODBC 0.34 - dependency on Perl 5.0 patchlevel 6 subversion

2002-02-08 Thread martin
On 08-Feb-2002 Jeff Urlwin wrote: Martin, Do you get any warnings when you run it? I found them annoying, but I will comment out the no warnings... [martin@brimer DBD-ODBC-0.34]$ make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux

RE: PPM for DBI 1.20 available

2002-02-08 Thread Sterin, Ilya
Ooopsss. That's what I meant. ppm install http://www.xmlproj.com/PPM/DBI-1_21.ppd Ilya -Original Message- From: KAWAI,Takanori To: Sterin, Ilya; [EMAIL PROTECTED] Sent: 2/8/02 1:56 AM Subject: Re: PPM for DBI 1.20 available Hi. - Original Message - From: Sterin, Ilya [EMAIL

RE: Perl DBI-connect

2002-02-08 Thread Khamneian, Mahtaj
After some debugging using DBI-trace, I found out the value of the password is not passed correctly to DBI-connect (hard coding the password directly in connect worked). Apparently split is attaching something (eoln?) to the password value which makes it invalid when passed to oracle via

Bizarre Oracle problem - malloc issue?

2002-02-08 Thread Berger, Daniel
Perl 5.6.1, DBI 1.20, DBD-Oracle 1.12 I have this simple program that was working fine yesterday. This morning I'm getting odd problems. The only database connection I make is the very simple query I make in the 'getHosts()' sub. The query seems to run fine - I get results and I can step

Re: Perl DBI-connect

2002-02-08 Thread Ronald J Kimball
On Fri, Feb 08, 2002 at 12:39:59PM -0600, Khamneian, Mahtaj wrote: while($line = INPUT) { chomp $line; my @login=split(/:/,$line); Ronald

RE: Perl DBI-connect

2002-02-08 Thread Cliff Nadler
Make this line: my @login=split(/:/,$line); be this: my @login=split(/:/,chomp($line)); You are getting hit with the end-of-line character. On Fri, 8 Feb 2002, Khamneian, Mahtaj wrote: After some debugging using DBI-trace, I found out the value of the password is not passed

Re: Bizarre Oracle problem - malloc issue?

2002-02-08 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Feb 08, 2002 at 01:00:37PM -0600, Berger, Daniel wrote: However, as soon as I try to step into the someOtherSub() sub, the program dumps me into the Oracle.pm module. I never even get to the first line of someOtherSub(). It dies *at*

Re: Perl DBI-connect

2002-02-08 Thread Douglas Wilson
From: Cliff Nadler [EMAIL PROTECTED] my @login=split(/:/,chomp($line)); This does not do what you think it does. 'chomp' returns the number of characters removed. Check the docs. HTH, Douglas Wilson

Re: Perl DBI-connect

2002-02-08 Thread Cliff Nadler
True, it should be chomp $line; my @login=split(/:/,$line); On Fri, 8 Feb 2002, Douglas Wilson wrote: From: Cliff Nadler [EMAIL PROTECTED] my @login=split(/:/,chomp($line)); This does not do what you think it does. 'chomp' returns the number of characters removed. Check the docs.

Re: Bizarre Oracle problem - malloc issue?

2002-02-08 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Feb 08, 2002 at 02:20:21PM -0600, Berger, Daniel wrote: I understand that. What I don't understand is why it's dumping there in the first place if I've already successfully closed (i.e. disconnected) the (one and only) database handle.

RE: Perl DBI-connect

2002-02-08 Thread Khamneian, Mahtaj
The script works beautifully. Thanks a bunch to all who helped. -Mahtaj -Original Message- From: Cliff Nadler [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 1:39 PM To: Douglas Wilson Cc: Khamneian, Mahtaj; [EMAIL PROTECTED] Subject: Re: Perl DBI-connect True, it

DBI Datatypes and ODBC

2002-02-08 Thread Matt Ramadanovic
Folks, After reading searching around Usenet and Programming the PERL DBI I still can't find any concrete examples to help me do what I have to do. All I am doing is inserting data into a database. The data comes from a few different place but ends up in two synced arrays (the keys are

DB2 Common Table Expression + DBD::DB2 problem

2002-02-08 Thread Phil Estes
I have several Perl scripts (currently being used under Win2k + ActiveState + DBI 1.14 / DBD-DB2 0.75) which use DB2 common table expressions (WITH CTE( .. ) UNION ALL .. fullselect ) which have been running just fine for about 6 months or more now. A production DB2 server had to be upgraded to

FW: Bizarre Oracle problem - malloc issue?

2002-02-08 Thread Berger, Daniel
snip I think you're confusing END with DESTROY. `perldoc perlmod`. Damn - you're right. What am I thinking? Anyway, when I just run it at the command line it just...dies. No warnings, errors, no nothing. It was very weird. A few hours later, it started working again, without any logic

Re: Doc update for finish method

2002-02-08 Thread Tim Bunce
[moved from dbi-dev to dbi-users] On Fri, Feb 08, 2002 at 11:56:25AM -0600, Paul DuBois wrote: ! When all the data has been fetched from a CSELECT statement, the ! driver should automatically call Cfinish for you. So you should ! Inot normally need to call it explicitly Iexcept when you know

Re: Embedding perl in Oracl

2002-02-08 Thread Tim Bunce
On Fri, Feb 08, 2002 at 11:42:25AM -0600, Scott T. Hildreth wrote: On Fri, Feb 08, 2002 at 12:25:45PM -0500, Richard A. Nakroshis wrote: yes is does, but you can get it at, ftp://pause.perl.org/pub/PAUSE/authors/id/TIMB/ But please don't. pause.perl.org is meant only as an upload area and

Re: Doc update for finish method

2002-02-08 Thread Douglas Wilson
From: Tim Bunce [EMAIL PROTECTED] What's an example where having finish() after the loop actually makes a difference? I'm trying to understand why is it a mistake, as opposed to simply being superfluous? Consider doing a select returning many rows some of which are either a) LONGs

CPAN Upload: T/TI/TIMB/OraclePerlTalk_200201.ppt

2002-02-08 Thread PAUSE
The uploaded file OraclePerlTalk_200201.ppt has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/OraclePerlTalk_200201.ppt size: 179712 bytes md5: c76358d7af850211af32a3b18bc48b3d No action is required on your part Request entered by: TIMB (Tim Bunce) Request entered on: Fri, 08

fetchrow_array problem

2002-02-08 Thread Ashwini Pande
hi, I have a perl script here which fetches data from the mysql database using the fetchrow_array method. I have this script running on 2 different machines. unfortunately this fetchrow_array call works on one machine and not on another. I used the rows calls to check how many rows are

RE: Perl DBI-connect

2002-02-08 Thread Jeff Urlwin
Mahtaj, Try chomp($line); before the split. Jeff After some debugging using DBI-trace, I found out the value of the password is not passed correctly to DBI-connect (hard coding the password directly in connect worked). Apparently split is attaching something (eoln?) to the

RE: DBI Datatypes and ODBC

2002-02-08 Thread Jeff Urlwin
Matt, In the DBD::ODBC test suite (t/* files), you will find examples of how to do such things in a very cross-database way. In the 'non-standard' tests, which are not guaranteed to run anywhere but here :), I have some things that I run to ensure things still work for me. Look at testfunc.pl

FW: PPM repository status (as related to DBD::ODBC)

2002-02-08 Thread Jeff Urlwin
FYI, for those using ActiveState's PPM. Regards, Jeff Hi Jeff, Is this for all modules or just Tk? DBD::ODBC is a month out of date. It should be all the modules. I checked the build logs, and it looks like the system run out of disk space a couple of times during the builds, so about 30