Unanswered: Passing ADO Recordset to Oracle stored procedure
Can we pass a recordset from a VB application to a Stored Procedure
written in Oralce. If any one has any idea about this please respond.
I am using ADO 2.7, VB6 and Oracle 9i.
Thank you in advance
I have some experience using Oracle 9i and Programming Visual Basic 6.0 and Visual C++. Recordset its a set o records that is involved with database in 2 ways. DAO and ADO. ADO, I recommend you make connections via ODBC or OLE DB. Oracle install both of them. By those ways you should use SQL instructions into your program. According you want oracle provides procedures, functions and packages. I highly recommend use packages, because they are useful when you need to returns data cursors to the program.