[EMAIL PROTECTED] To: Denesa K Shaw [EMAIL
PROTECTED]
ax.co.jpcc: dbi-users@perl.org
Subject: Re: Calling Stored
Procedure using
On 4/18/05, Denesa K Shaw [EMAIL PROTECTED] wrote:
DBI::db=HASH(0x2035aef0)-disconnect invalidates 1 active statement handle
(either destroy
statement handles or call finish on them before disconnecting)
Well, you need either destroy statement handles or call finish on
them before
:
Subject: Re: Calling Stored
Procedure using REF CURSORS
04/18/2005 02:04
PM
Denesa,
(cc to dbi-users, hope you don't mind)
glad it worked.
Now I'm trying to close the
cursor, Would I close the cursor similar to the code below (does not
work
by the way)?
I don't really understand that code below...
According to the DBD::Oracle docs, you have to close a ref cursor like
Not sure why you what the stored procedure looks like, but why are you using
the ref cursor both as a parameter and a return value? If it was a
procedure you would just have it an an IN OUT parameter, with just
BEGIN Package.Pr_Get_Config_System_Path(:p1,:out_cursor); END;
and vice versa if it
Hi, I'm calling an external Stored Procedure written in PL/SQL that
includes one input argument and an output argument that is a REF
CURSOR.
When I run the code I get the error's indicated below. Any ideas on
what
needs to be changed?
If it is a procedure (as opposed to a function), it does not