RE: make fails with "ld: cannot open libgcc.a" for DBD::Oracle on AIX 5.1, gcc

Hi, We installed perl 5.8 & DBI & DBD using the same platform u mentioned. AIX 5.2 Oracle 9.2.0.2 perl v5.8.3 DBI 1.41 DBD-Oracle 1.15 But we never succeeded using "gcc". Try to install everything (perl & DBI & DBD ) using xlc_r. You can find xlc_r trial versions...then u can buy the origin

make fails with "ld: cannot open libgcc.a" for DBD::Oracle on AIX 5.1, gcc

Hi, I'm trying to get DBD::Oracle to compile using AIX 5.1 Oracle 8.1.7.4 gcc 2.9-aix51-020209 perl v5.8.3 DBI 1.41 I compiled this perl and DBI with gcc just fine. Other CPAN modules compile OK with gcc. We don't have xlc or cc compilers; is this even possible? I've tried setting the LIB/

RE: Problem related to oracletool ...

No, but if you upgrade your perl to the latest, you can get them from my site ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBI.ppd and DBD-Oracle.ppd Jeff -Original Message- From: Harsh Agrawal [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 9:54 AM To: Jeff Urlwin; [EMAIL PROTECT

How to write Perl script for testing a module

Hai Friends, I would like to write a test script for testcases. I got some information thru google that's about Test::Harness module. But, i did'nt get complete information to write testscript for my project module. If anybody can please guide me... Thanks Mahi G -

How to write Testscript in perl

Hai Friends, I would like to write a test script for testcases. I got some information thru google that about Test::Harness module. But i did'nt get complete information to write testscript for project module. If anybody known or experienced people. Please guide me... Thanks Mahi G --

Doc patch for DBD-Oracle: Handling LOBs

Hello dbi-users, I am a very happy user of DBI and DBD::Oracle. And some days I am using the new Handling of LOBs in DBD::Oracle. IMHO there is a mistake in the documentation. I am using Oracle 8i. Not shure about 9 or 10g. I am running on Windows, but should be the same on Unix. In http://sear

Re: DBI and Mysql Insert

I'm only familiar with the "build the SQL" method, but if there's an alternate method it would be described in the excellent DBI perldocs, which you can access by doing perldoc DBI at a command prompt. HTH. Hardy Merrill >>> "Chris Faust" <[EMAIL PROTECTED]> 03/12/04 09:33AM >>> Good Morni

RE: Problem related to oracletool ...

Title: Message I installed DBD-Oracle from http://ppm.activestate.com/PPMPackages/   Any idea from where I can get 1.13 version containing PPD file. From: Jeff Urlwin [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 4:44 PMTo: Harsh Agrawal; [EMAIL PROTECTED]Subject: RE: Problem rel

RE: Problem related to oracletool ...

>From the Message below and reading the Changes in DBD::Oracle, you will find that ora_session_mode was added in DBD::Oracle 1.13. You need a newer version. Regards, Jeff -Original Message- From: Harsh Agrawal [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 8:41 AM To: [EMA

DBI and Mysql Insert

Good Morning, Please forgive if this is considered off topic, I thought it would be the best place to start. I think I have a very simple question, I have a perl hash in which all the keys are my tables field names and the values are the values that I wish to insert into my table. Is there is

Problem related to oracletool ...

Hi,   I am facing some problem related to a Oracle Tool called "oracletool" available @ www.oracletool.com   Below are the details:   I am using: Windows 2000 ProfessionalActiveState Perl 5.6.1Apache 1.3.22DBI 1.34 DBD-Oracle 1.12 Oracle Enterprise Edition 9.2   All are successfully instal

Re: help required for DBI script!

Problem solved. :-) Samuel pointed out the cause of the error -> it was connecting to one database when it should have been connecting to the other one. Thanks everybody and especially to Sam. Marc Torres Alvarez

Re: help required for DBI script!

> I have this script that keeps bugging me with an Oracle error ORA-00942 that > should not be there. All the tables in the script are owned by 'DBREPORTER' > who is running the script. I have executed the same SQL commands directly > with SQLPlus and they work fine. Even more, the same SQL command

RE: help required for DBI script!

I did that but it did not help. The same error still pops up. Any ideas anybody? Regards, Marc Torres Alvarez Hey Marc, Try putting a $sth1->finish(); before you do the next do statement. See your code below, I marked it with *** Try that and see if it helps. Thanks, Sam Gold -Origi

RE: help required for DBI script!

Hey Marc, Try putting a $sth1->finish(); before you do the next do statement. See your code below, I marked it with *** Try that and see if it helps. Thanks, Sam Gold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 7:10 AM To: [EMAIL P

RE: "identifier too long"?

Notice too that in Jeff's example he used the q() construct which is fine too when using placeholders since no variables need to be interpolated. >>> "Mark Galbraith" <[EMAIL PROTECTED]> 03/11/04 06:00PM >>> Jeff Zucker wrote: > Your quote marks were messing you up and

help required for DBI script!

Hi all I have this script that keeps bugging me with an Oracle error ORA-00942 that should not be there. All the tables in the script are owned by 'DBREPORTER' who is running the script. I have executed the same SQL commands directly with SQLPlus and they work fine. Even more, the same SQL command

RE: DBI with ORACLE encryption

I would go with the latest and greatest. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 12:50 AM To: Gold, Samuel (Contractor); [EMAIL PROTECTED] Subject: RE: DBI with ORACLE encryption Hi, We have tried this way of connecting as well

RE: DBI with ORACLE encryption

Hi, We have tried this way of connecting as well. This again seem to be not working. We are using the DBI version 1.06. From your mail, we find that it is working for DBI vesion 1.35. Does this mean that we have to upgrade the DBI ? If so, to which version? Regards Jayashree Ability is w

RE: "identifier too long"?

Jeff Zucker wrote: > Your quote marks were messing you up and the easiest way to > avoid that > and other problems is to use placeholders (the ? in the $sql_dmd). Or use the Perl qq() construction which avoids the problem alltogether. -- Mark Galbraith CERT UNIX Appli

RE: "identifier too long"?

That's an Oracle error and a quick search on Metalink indicates that this tends to happen with tools like Pro*C and if DBD::Oracle uses the OCI like Pro*C then this bug will apply also. It is reproducable in 8.1.x 9.0.x and 9.2.0.1 ... Apparently the solution is (guess what?) upgrading to Oracle 10