----- Forwarded message from "Grimes, Greg" <[EMAIL PROTECTED]> -----
Delivered-To: [EMAIL PROTECTED]
Subject: Pass Arrays to Stored Procedures in Oracle
Date: Wed, 13 Aug 2003 14:28:38 -0500
From: "Grimes, Greg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>, "Steve Baldwin" <[EMAIL PROTECTED]>
X-OriginalArrivalTime: 13 Aug 2003 19:28:38.0385 (UTC) FILETIME=[1883B610:01C361D1]
Steve,
I saw your posting concerning pipelined functions. How does the perl script benefit
from this approach? I would assume the perl script can consume the return without
having to wait until the entire array is returned.
Tim,
Is there anyway, short of giving you money, to pass an array to a stored procedure?
In an examples:
$sth1->bind_param_inout(":cursor", \$sth2, 0, { ora_type => ORA_RSET } );
the ":cursor" is returned from the stored procedure. Could that same ":cursor" be
passed to another stored procedure that is expecting a cursor/array as a parameter?
The reason I ask is that a ref cursor will be hitting an Oracle database and then
passing that result set to another Oracle database instance if possible.
Both,
Any comparison in terms of performance between a ref cursor and routine queries?
Thanks.
----- End forwarded message -----
