
Using oracle stored procedures/functions to return result sets
Hi
does anyone know how to do this?
I have tried using a ref cursor as the return type of a stored procedure in
oracle but have
no idea how i should call this from VB. I would imagine the calling syntax
would be
{ ? = call myPackage.GetResultSet( ? ) }
where the second parameter is an integer and the first parameter is a result
set.
How do i tell vb the first parameter is a result set?
should i execute the query or call .OpenResultSet on the query?
any ideas would be much appreciated
thanks
hugh