the pinned procedure would not be faster than the lone
insert statement using bind variables and multiple
executes. on the sql end they both do the same thing.
static sql or dynamic sql with bind variables in the
pl/sql block is hashed and reused as well.
what possibly makes you think having pl
> To: Powell, Bruce
> Cc: 'Scott T. Hildreth'; [EMAIL PROTECTED]
> Subject: Re: Multiple IN variables for Oracle Procedure
>
>
> On Fri, Jun 14, 2002 at 09:25:33AM -0600, Powell, Bruce wrote:
>> Yes, I did test it first with a simple insert statement. The reason I a
dreth'; [EMAIL PROTECTED]
Subject: Re: Multiple IN variables for Oracle Procedure
On Fri, Jun 14, 2002 at 09:25:33AM -0600, Powell, Bruce wrote:
> Yes, I did test it first with a simple insert statement. The reason I am
> using a procedure is speed. I can pin the procedure in memo
han doing execute() calls
on a prepared statement handle?
Have you actually benchmarked it?
Tim.
> -Original Message-
> From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 14, 2002 09:19 AM
> To: Powell, Bruce
> Cc: [EMAIL PROTECTED]
> Subject: RE: Multi
#x27;; Powell, Bruce
Cc: [EMAIL PROTECTED]
Subject: RE: Multiple IN variables for Oracle Procedure
Yes, I did test it first with a simple insert statement. The reason I am
using a procedure is speed. I can pin the procedure in memory and save time
on multiple inserts.
-Original Messag
: Powell, Bruce
Cc: [EMAIL PROTECTED]
Subject: RE: Multiple IN variables for Oracle Procedure
Have you tried running it from the command line, not as a CGI script?
This may be an example, but you really don't need a stored procedure here.
$sth = $dbh->prepare('insert into some
Have you tried running it from the command line, not as a CGI script?
This may be an example, but you really don't need a stored procedure here.
$sth = $dbh->prepare('insert into some table values(?,?)');
$sth->execute($data1, $data2).
...but your procedure may do alot more than you sent here.