On Mon, Jan 08, 2007 at 09:46:09PM +, Nathan Morrow wrote:
> Below are the test runs of the following script:
>
> Test the new proposed version
>-> ora_fetch
><- () [0 items]
> $ora_errno is DEFINED
> $ora_errno = 0
>!! warn: 0 CLEARED by call to finish method
>-> finish
x29d5b0)~0x12f2bc)
<- disconnect= 1 at Oraperl.pm line 101 via test_fetch.pl line 22
-> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x29d784)~INNER)
<- DESTROY= undef
-> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x12f2bc)~INNER)
<- DESTROY= undef
Try this (untested):
--- oci8.c (revision 7883)
+++ oci8.c (working copy)
@@ -1672,6 +1672,9 @@
if (status == OCI_NO_DATA) {
dTHR; /* for DBIc_ACTIVE_off */
DBIc_ACTIVE_off(imp_sth); /* eg finish*/
+if (DBIc
You should read the Oracle SQL*Plus docs for the meaning of "/" as a
username.
-Original Message-
From: Gupta, Razat [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 06, 2005 11:35 PM
To: dbi-users@perl.org
Subject: Oraperl
Hi EveryOne,
I have a query related to Oraperl.
Actually
>-Original Message-
>From: Sid Katz [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, August 02, 2005 12:14 PM
>I am converting oraperl statments to the new Perl-DBI format and do
>not entirely understand the Perl-DBI syntax. I have included code
>with the oraperl method and what I think is the c
On Mon, May 10, 2004 at 10:11:29AM -0500, Gram M. Ludlow wrote:
> Good morning!
> I have been in charge of installing Oraperl on a bunch of our HPUX systems.
Oh joy :)
> I resolved the issue. I thought you might want to add it to your
> README.HPUX at some point.
Thanks.
Tim.
On Tue, 15 Jul 2003 10:26:48 -0400 Divyesh Thakker <[EMAIL PROTECTED]> wrote:
> I have a question for Oraperl that hopefully you can answer.
>
> We currently have Oraperl (perl4) running on Solaris 2.6 connecting to a
> Oracle 7.3.3 DB.
> We need to upgrade the server to Solaris 9 and am wonderin
.
Give a hobbit a ring and he eats fish for an age.
- Original Message -
From: "Michael A. Chase" <[EMAIL PROTECTED]>
To: "Anshu Anshu" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 23, 2001 06:49
Subject: Re: Oraperl -> DBI
> The scrip
The script already has a 'use Oraperl;' line which is all that should be
needed to use the Oraperl emulation that comes as part of DBD::Oracle. The
Oraperl emulation is provided specifically to allow old scripts that use
oraperl calls to continue to work with minimal changes.
A much much bigger
database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Ted X Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001
To: <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 10:51 AM
Subject: Re: Oraperl, DBI,DBD , ARRAY PROCESSING and performance issue
> My program didn't use any bind variable, prepared statement.
> The BIND variable and prepared stmt definitely will speed up the program,
but withou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, Jan 25, 2001 at 09:27:40AM -0500, Ted X Wang wrote:
>
>
> Hi,Gurus:
>
> I'm looking for some help to spped up my perl application.
>
> It's a data loading program written in Oraperl, perl5.02.
>
> Each morning, we need to load about 50,0
X Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 11:03 AM
Subject: Re: Oraperl, DBI,DBD , ARRAY PROCESSING and performance issue
> I didn't have set any of them. It's a default installation with an old
perl, oraperl.
>
> It&#x
Do you have AutoCommit = 0?
Are you using bind variables?
Did you prepare the SQL outside your loop?
How many indexes do you have on the table while inserting?
--
Mac :})
** I may forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a
14 matches
Mail list logo
