Saul Roquemore wrote: > I'm trying to call an Oracle stored procedure that returns a cursor. > I've found numerous examples for calling functions. There are many > examples calling a stored procedure and passing one or more > parameters. However, I can't find a call to a procedure that opens > a cursor and returns it. > > The stored proc I'm calling has been compiled and works within a > Visual Basic program. I'm not a VB programmer but I'd like to use > the code in the PL/SQL procedure. > > Here is the spec: > PROCEDURE getCustInfo( IO_CURSOR IN OUT T_CURSOR );
http://theoryx5.uwinnipeg.ca/CPAN/data/DBD-Oracle/Oracle.html#Binding_Cursors -- Andy Hassall ([EMAIL PROTECTED]) icq(5747695) (http://www.andyh.co.uk) Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
