RE: Building the Right Perl/DBD Document

Thanks Sanjay! Rick -Original Message- From: WAZA,SANJAY (Non-HP-PaloAlto,ex1) Sent: Monday, August 19, 2002 11:13 AM To: LEE,GORDON (HP-SantaClara,ex2); GANESAN,MAYA (HP-SantaClara,ex4); RAMAN,SETHU (Non-HP-SantaClara,ex2

Building the Right Perl/DBD Document

HI All, Please refer to the attached document that you might need for any future references to build the right Perl (5.6.1) and DBI/DBD on HP UX 11.0(64 BIT) against Oracle9i . Thanks Sanjay <> After days of Frustration her is the Mantra to make DBD

RE: DBI Error

object file - PA-RISC 2.0 (LP64) So it is a 64 Bit Object . Does this mean cc is 32 bit ? I am not sure why i am getting "Mismatched ABI. 64-bit PA object file found in 32-bit link." Or do I need to rebuild Perl with +z flag option ? Thanks Much Appreciated your help Sanjay -Orig

RE: DBI Error

12:50 libocijdbc9_g.sl -rw-r--r-- 1 oracle dba 211302 Apr 26 04:01 libocijdbcst9.a So I am not sure how to find exactly which shared library it is looking for ? Thanks Sanjay -Original Message- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 18, 2002

DBI Error

I am running this simple script on HP UX 11.0 (64 BIT) . The database is Oracle 9.2.0 #!/opt/perl5.6.1/bin/perl use DBI; print "hello\n" ; $dbh = DBI->connect(mydb,scott,tiger,'Oracle') ; I am getting this error install_driver(Oracle) failed: Can't load '/opt/perl5.6.1/lib/site_perl/5.6.1/PA-R

Oracle and date conversion

Hi, I'm using a Oracle table in which date are stored in number of seconds since January 1st 1970. I've been succesfully able to convert number of seconds to a correct format string (-MM-DD HH:MM:SS) using DateTime::Precise module, but I don't know how to do the reverse operation. Is there

RE: :Oracle

Hi, > Check the archives, but in a nutshell it can't be done. Two oprions > 1. Install the oracle client, (Client is free after all) I'm using HP/UX on a PA-RISC 32bits. There are no available version of Oracle for this architecture (only for 64 bits PA-RISC). > 2. Install the DBD::Proxy module

DBD::Oracle

Hi, I'm currently trying to compile the DBD::Oracle driver on a HP/UX platform. I want to access a distant Oracle database, and Oracle is not installed on my local machine. And the compilation of this driver seems to require Oracle installed on the local machine. Do you have any advices/links or

Insert : how to get the primary key

Hi, I'm currently writing a Perl script which insert lots of data into a database. When I insert a row in a table, I need to get the PRIMARY KEY which has been affected to this table, because I will use it to reference this record in an other table. Currently, I issue a INSERT, and then a SELECT

Oracle 8.0.6 DBI/DBD issue.

Hi, I need some help . I have been trying this stuff make work for a couple of days now. The OS is HP UX 11.0 running perl 5.005_03 . DBI 1.14 and DBD-1.07 for Oracle .Recently we migrated the Oracle Database from 8.0.5 to 8.0.6 After migration the DBI and Oraperl scripts stopped worki

PERL MODULE DBD::ODBC

Hi all, I am having a problem installing the above module (Version 0.32). I have succeeded in the past with a statically linked version but cannot get the dynamic one going. The driver I'm using is Redbrick (a data warehouse now provided by Informix (IBM)). The only tweak that I have made is a

Error while building DBD Oracle driver

Hi all, I'm using Perl 5.004_04 built for PA-RISC1.1 on HP-UX B.11.00 and Oracle 8.0.5 I am installing DBI 1.20 and DBD-Oracle-1.08. I could successfully install the DBI. While installing the DBD I got foll. error. syntax error at Makefile.PL line 808, near "'' for " syntax err

re: Re: perl data structure for Oracle "index-by table"

> "Marty" == m keane <[EMAIL PROTECTED]> writes: Marty> This is what I'm looking for. My point about the Marty> foreach/fetchall_arrayref was only to indicate my Marty> limited experience using fetchall_arrayref. That's the Marty> only programming context in which I've used it. Fair enough.

Remove me from the list pls.

<[EMAIL PROTECTED]@perl.org>

RE: Prepare/Finish question

Hi Tim, $sth->finish This Indicates that no more data will be fetched from this statement before it is either prepared again or destroyed and to allow the server to free up any internal resources (such as read locks) currently being held. It does not affect the transaction status of the session.

LongReadLen

Hello , What is the max length that could be set for LongReadLen DBI attribute . Your help is appreciated . Tx Dan

Re: Search query on the fly

> "Mike" == MikeBlezien <[EMAIL PROTECTED]> writes: Mike> I don't believe MySQL supports REFERENCES in the CREATE TABLE. Mike> Is there an alternative using MySQL?? Actually, MySQL does support the syntax, it just doesn't do anything. (At least, this has been the situation for the last two

RE: best way to select 1 row

>>>>> "Tony" == Tony Foiani (non-HP) <[EMAIL PROTECTED]> writes: Tony> Note that this probably won't do what you want (unless Tony> "selectrow_array" is smarter than I expect), since you're trying Tony> to assign an array value (on th

Re: bind param problem

> "Michael" == Michael Peppler <[EMAIL PROTECTED]> writes: Michael> There was a fairly long thread in comp.databases.sybase on Michael> this issue. Joe Celko weighed in with this comment: Found it. http://www.deja.com/[ST_rn=ps]/threadmsg_ct.xp?AN=714120405&fmt=text Michael> 4) Attempti

Fixed-width CHAR compares (was: RE: Oracle & DBI)

> "Michael" == Michael Officer <[EMAIL PROTECTED]> writes: Michael> Thanks for the reply. Discovered that the problem isn't with Michael> placeholders, seems to be a problem related to datatypes. I Michael> mistyped my original example and misled you! It actually Michael> works! Here's the