Using oracle stored procedures/functions to return result sets 
Author Message
 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



Tue, 03 Apr 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. MSSQLServer->Oracle: Identity and returning a result set using oracle procedure or function

2. Returning result set from function to stored procedure is very slooooooooow

3. Returning a result set from a table using a stored procedure

4. Can't update result set returned from stored procedure using RDO

5. Can't update result set returned from stored procedure using RDO

6. Returning result sets in oracle stored procedure (OLEDB)

7. Returning result sets in oracle stored procedure (OLEDB)

8. OLE ,Oracle, ans Stored Procedures returning result sets

9. Oracle stored procedure returning a result set

10. function/procedure returning result set

11. best way to return a paged result set from a stored procedure

12. Return result set from stored procedure, possible ?


 
Powered by phpBB® Forum Software