Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

How do I bind cursors from an Oracle Stored Procedure?

by KoRny (Initiate)
on Apr 04, 2001 at 00:49 UTC ( [id://69472]=perlquestion: print w/replies, xml ) Need Help??

KoRny has asked for the wisdom of the Perl Monks concerning the following question:

I want to get data from a stored procedure that looks like this:
table.func(cust IN Char, cv OUT REF CURSOR)
This returns a cursor containing the data. But I have not yet found a way to extract that data. I have tried to look it up and have only come up with the bind_param() method to bind my values to the IN paramater. Is there another method to bind a variable/array to the cursor being returned?

Originally posted as a Categorized Question.

Replies are listed 'Best First'.
Re: How do I bind cursors from an Oracle Stored Proc.?
by arturo (Vicar) on Apr 04, 2001 at 01:35 UTC

    Check out bind_param_inout(), which IIRC is lightly documented and only works with Oracle at the moment. Good luck, I ended up scrapping the use of procedures and doing stuff by hand when I ran into these problems.

Re: How do I bind cursors from an Oracle Stored Proc.?
by astroboy (Chaplain) on Aug 02, 2004 at 09:03 UTC
    You actually have to use a package. It's very simple, but quite powerful. Have a look at curref.pl - it comes with DBD::Oracle and is found in the Oracle.ex directory

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://69472]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others cooling their heels in the Monastery: (4)
As of 2024-04-20 00:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found