How do I bind cursors from an Oracle Stored Procedure?

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)
[download]

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.

Comment on How do I bind cursors from an Oracle Stored Procedure? Download Code

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.	[reply] [d/l]
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	[reply]