Oraperl is a Perl 4 binary with the Oracle OCI calls compiled in. If you
are using 'Oraperl' with Perl 5, you are actually using the oraperl
emulation layer provided as part of DBD::Oracle. It is provided to allow
Perl 4 code to run without major changes, but it shouldn't be used for new
development.
Since you are using Perl 5, you definitely can use bind variables and stored
procedure calls (scalar arguments only). Run 'perldoc Oraperl' and 'perldoc
DBI' to see how. Because Oraperl is emulated over DBI and DBD::Oracle, the
connection and statement handles are actually DBI objects so you can use
them to make DBI method calls.
Preparing the SQL outside the loop, using bind variables, and turning off
AutoCommit will give you significant performance improvements over what it
sounds like you are doing now. To get help beyond these generalities, you
will need to show some of your code to the mail list.
--
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 hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Ted 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's written years ago and the ORAPERL interface doesn't really support
the bind variable, stored proc,
> let alone the ARRAY processing.
>
> It has nothing to do with the commit,index etc. Most of the time is spent
on the network traffic.
> Do you know any new ORAPERL that support ARRAY processing? or Should I
switch to the new
> version perl ?
