Oracle to ADO Recordsets

By | 2002-04-20

It allows the user to access Oracle Stored Procedures from VB, including getting ADO recordsets back

Original Author: Aparajit Agarwal

Inputs

Please read comments in the beginning of the code. Also, you must know how to structure and use REF cursors in ORACLE

Assumptions

Read the comments at the beginning thoroughly and call the sp_getdata method appropriately from a Client and you should be set.

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)

Attachments

FileUploadedSize
CODE_UPLOAD3723322000.zip9/3/2020 3:45:00 PM11812
Author: dwirch

Derek Wirch is a seasoned IT professional with an impressive career dating back to 1986. He brings a wealth of knowledge and hands-on experience that is invaluable to those embarking on their journey in the tech industry.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.