Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Perl DBI/Oracle 8iR3 Cursor return variable

Re: Perl DBI/Oracle 8iR3 Cursor return variable

From: Andy Finkenstadt <kahuna_at_panix.com>
Date: 7 Aug 2001 17:46:40 -0400
Message-ID: <9kpnk0$hvq$1@panix6.panix.com>

In <9kmr9s$dcr$1_at_panix6.panix.com> kahuna_at_panix.com (Andy Finkenstadt) writes:
>I have not yet found a way to do what I do with OO4O on Windows,
>namely return a cursor variable through a Perl DBI/DBD::Oracle
>PL/SQL call, similar to:
> begin
> schema.package.procedure( parm => :parm, cursor_out => :cursor );
> end;
>where :parm is bound as in input parameter, and :cursor is bound
>as an out parameter.

Almost this exact example is found in the latest DBD::Oracle version 1.08 released in the last couple of days, in .../Oracle.ex/curref.pl, and demonstrates how to return a ref cursor back to a perl program.

-Andy
 answering his own question.

-- 
Andrew Finkenstadt (http://www.finkenstadt.com/andy/)

Your question was: Oh Oracle most wise, if knowledge is power, what's ignorance?
Thus spake the Oracle: Horsepower.
Received on Tue Aug 07 2001 - 16:46:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US