Home » SQL & PL/SQL » SQL & PL/SQL » returning cursors to ado objects from stored procedure
returning cursors to ado objects from stored procedure [message #38757] Mon, 13 May 2002 00:59 Go to next message
Andrea
Messages: 15
Registered: February 2002
Junior Member
hi,
I read on msdn that it's possible to return cursors to vb from oracle stored procedures (with OLE DB Provider for ODBC Drivers and the Microsoft ODBC Driver for Oracle) and so I did but opening the ado recordset I get an error message:
'odbc driver does not support the requested properties'
may you help me giving an example of vb code for returning a ref cursor from a procedure with 1 input parameter and a ref cursor out parameter? thanks a lot
PS: I don't want to return table types, ok?
Re: returning cursors to ado objects from stored procedure [message #38762 is a reply to message #38757] Mon, 13 May 2002 09:24 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Andrea, I would refer you to this link which has result set examples for numerous front-ends including ODBC and ADO/ASP.

http://osi.oracle.com/~tkyte/ResultSets/index.html
Previous Topic: how to delete specific number of records in a table
Next Topic: Using global temp tables
Goto Forum:
  


Current Time: Thu Apr 25 22:32:32 CDT 2024