by Aparajit Agarwal (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(7 Votes)
It allows the user to access Oracle Stored Procedures from VB, including getting ADO recordsets back
Inputs
Please read comments in the beginning of the code. Also, you must know how to structure and use REF cursors in ORACLE
Assumes
Read the comments at the beginning thoroughly and call the sp_getdata method appropriately from a Client and you should be set.
Code Returns
ADO recordset from ORACLE. However,version 8.0.5 at minimum (to the best of my knowledge)
Side Effects
None that I know of. Currently the code is not updated to include type of recordset (Disconnected or connected)
VBcoders