Does DBD-ORACLE support Oracle 9i 64 bit ?

Hi, We have just upgraded to Oracle 9i 64 bit from Oracle 8.1.7 32 bit and I have been trying to re-install my DBD version 1.07 and am getting an error of ld: fatal: file /usr/local/opt/oracle/product/9.2.0/rdbms/lib/defopt.o: wrong ELF class: ELFCLASS64, does anyone know of a way to override

DBD-Oracle-1.14 and Oracle 9i

Has anyone been able to compile DBD-Oracle-1.14 with Oracle9i under Solaris8? Joe Potenza [EMAIL PROTECTED]

DBI 1.40 problem to build on HP-UX

Hello, everybody. I'm trying to build DBI 1.40 with perl 5.8.0 from perl2exe. The make command returns me following: cc: "/disk1/perl_comp/perl2exe/perl5/lib/5.8.0/PA-RISC2.0/CORE/perlio.h", line 209: error 1000: Unexpected symbol: "__attribute__". cc: "/disk1/perl_comp/perl2exe/perl5/lib/5.8.0

Re: Strange matching problem...

- Original Message - From: "Hardy Merrill" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 22, 2004 11:21 AM Subject: Re: Strange matching problem... > HM>> I don't see any matching logic in your code below, but here's a > general thought - instea

Error on install of DBI 1.40

After doing perl Makefile.PL and then make, I get the following screen: cp Changes blib/lib/DBI/Changes.pm cp dbd_xsh.h blib/arch/auto/DBI/dbd_xsh.h cp lib/DBI/FAQ.pm blib/lib/DBI/FAQ.pm cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm cp DBI.pm blib/lib/D

Re: DBD::ADO and ODBC Information Code

Hello Summary of email sent earlier: Skipping the error step saves 3min in a 5 minute process, where it would take < 1 sec if data was returned. my $rs = $cxn->Execute("..."); # Takes 0:54 sec $_->Description, "\n" for Win32::OLE::in( $err ); # Takes 3:00 $err->Clear; # Takes 0

Re: DBD::ADO and ODBC Information Code

Hello Okay, I have done this and gotten interesting results. I littered the test scripts with print's so I could profile it. First output with print "$_->Description, "\n" for Win32::OLE::in( $err );" commented out. Note: a memory spike ( 300 meg ) happened in the Execute call (300 Meg ) and was

RE: Strange matching problem...

Hardy Merrill [EMAIL PROTECTED] wrote: > > You really need to read 'perldoc DBI' (at a command prompt) and pay > attention to how placeholders are used. See below. As Dave Murray > suggested, the Programming the Perl DBI book would be a good > investment. > > > $dbh->do(qq{ > >

Re: Strange matching problem...

Thanks for correcting me! My brain is not in Perl mode - I wanted to bind the start(^) and end($) of the line in the regex, but I couldn't remember if I could just stick the $acct2 in the regex, or if it would think the '$' in $acct2 would signify the end of the line. Thanks again. Hardy >>> "B

Re: Strange matching problem...

NIPP, SCOTT V (SBCSI) wrote: OK... From what I have read, the "prepare...execute" method is no more acceptable than the "do" method. My understanding is that if you are going to be inserting multiple instances, without looping, then you are better served with using the "prepare...execute

RE: Strange matching problem...

OK... From what I have read, the "prepare...execute" method is no more acceptable than the "do" method. My understanding is that if you are going to be inserting multiple instances, without looping, then you are better served with using the "prepare...execute" method. If you are looping

RE: Strange matching problem...

On Jan 22, NIPP, SCOTT V (SBCSI) scribed: > OK. I am working on converting this to use placeholders and the > "qq" quoting option. I am obviously very new to placeholders, so this is > probably a stupid question, but here goes. I execute the script and receive > the following error: > > [

RE: Strange matching problem...

Thanks to everyone for the feedback. I have modified the script to fix the NOW function. Thanks again. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: Strange matching problem...

I forgot to mention - be careful with the NOW() function - that is a function that many different database use to get the current date/time. That NOW function needs to be specified _in_ the SQL for the db - _NOT_ as a value specified to a placeholder in the "execute" - I learned this the hard way,

RE: Strange matching problem...

You really need to read 'perldoc DBI' (at a command prompt) and pay attention to how placeholders are used. See below. As Dave Murray suggested, the Programming the Perl DBI book would be a good investment. >>> "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> 01/22/04 02:52PM >>> OK. I am wor

Re: Strange matching problem...

Scott.. this is an example(a very simple one) of a way that i use placeholders my $enroll = Y; my $cpaid = 12345; my $sth = $dbh->prepare(q{ insert into war.rfrl_assn (CPA2BIZ_ENROLLED,CPAID) values (?,?) }) or die $dbh->errstr; $sth->execute($enroll,$cpaid) or die $dbh->errstr; of course, when

RE: Strange matching problem...

OK. I am working on converting this to use placeholders and the "qq" quoting option. I am obviously very new to placeholders, so this is probably a stupid question, but here goes. I execute the script and receive the following error: [EMAIL PROTECTED]:/home/sadmin/sn4265/perl> timex ./p

RE: Strange matching problem...

This time HM### - I hate Groupwise! Can't properly quote anything. >>> "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> 01/22/04 01:32PM >>> OK... First of all, today, this afternoon, I am going to learn how to use placeholders and get that fixed. I promise. :) HM### Your "non-placeholder"

RE: Strange matching problem...

OK... First of all, today, this afternoon, I am going to learn how to use placeholders and get that fixed. I promise. :) HM>> I don't see any matching logic in your code below, but here's a general thought - instead of a string equality check ( if ($acct1 eq $acct2) ), you could use a r

Re: Strange matching problem...

My comments below as HM>>. I'll repeat one general suggestion made previously - use placeholders :) >>> "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> 01/22/04 01:05PM >>> I am working on a script to gather data about Unix user accounts. This is going well so far and has gotten us some initi

Strange matching problem...

I am working on a script to gather data about Unix user accounts. This is going well so far and has gotten us some initial data such as almost 27000 user accounts across about 80 servers. I have built into the script and database some checking to track changes basically capture these chang

Re: DBD::ADO and ODBC Information Code

Peter Hircock wrote: > I would like to try that, would I apply the code below to the "error" > subroutine to limit the number of loops in the for loop. If I understand > this, I could have it leave the for loop once @Err reaches the > MAX_ERRORS. Better use my test script

Re: Can't make DBD

On Thu, Jan 22, 2004 at 02:01:17PM +, Sean Kelly wrote: > Quoting Tim Bunce <[EMAIL PROTECTED]>: > > > p.s. Of course I'd much prefer it if you (or anyone else) could > > just find and fix the problem and send me a fix. Then you get your > > name in the Changes file :-) > > I know what the

Re: DBD::ADO and ODBC Information Code

Hello I would like to try that, would I apply the code below to the "error" subroutine to limit the number of loops in the for loop. If I understand this, I could have it leave the for loop once @Err reaches the MAX_ERRORS. LINE: 50 if ( $Errors && $Errors->Count ) { for my $err ( W

Re: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

On Thu, Jan 22, 2004 at 01:39:47PM +0100, Joel Van Boeckel wrote: > Hi Tim, > Using the -l flag of perl Makefile.PL, I don't think that we pass thru the buid rule > discovery phase. > I send you the log of >- perl Makefile.PL -l >- perl Makefile.PL > > [EMAIL PROTECTED] DBD-Oracle-1.15 ]#

Re: Can't make DBD

Quoting Tim Bunce <[EMAIL PROTECTED]>: > p.s. Of course I'd much prefer it if you (or anyone else) could > just find and fix the problem and send me a fix. Then you get your > name in the Changes file :-) I know what the problem is, I just don't have time to fix it. On line 348 of Makefile.P

Re: DBD::ADO and ODBC Information Code

Peter Hircock wrote: > I know the ODBC driver is returning "SUCCESS_WITH_INFO" code 01001. > > [Reuters][Open Access][Reuters DB]I41249: Fewer than requested > number of rows retrieved because no more rows found (SQL-01001) > [Reuters][Open Access][Reuters DB]I41255: No rows returned because the

RE: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

Hi Tim, Using the -l flag of perl Makefile.PL, I don't think that we pass thru the buid rule discovery phase. I send you the log of - perl Makefile.PL -l - perl Makefile.PL Regards, Joël [EMAIL PROTECTED] DBD-Oracle-1.15 ]# perl Makefile.PL -l Using DBI 1.38 installed in /opt/perl5/lib/si

Re: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

Thanks for the info. I'll ask this again... did "build rule discovery" work for you? Can you send (just) me a log of "perl Makefile.PL" (use the script command). Tim. On Thu, Jan 22, 2004 at 12:05:01PM +0100, Joel Van Boeckel wrote: > Hi Tim, > > HP reccomendations > -- > Conce

RE: Can't make DBD: a solution on HP-UX 11.00 with Oracle 9i

Hi Tim, HP reccomendations -- Concerning HP requirements, I followed most of reccomendations from Garry Ferguson available at http://www.mail-archive.com/[EMAIL PROTECTED]/msg18687.html The most important difference concerns the LINKTYPE of dbi and dbd. I didn't force it to static