hi,
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

Mike

Hi!

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.

For stored procedures call sintax, use this:

CALL [package_name.]stored_procedure_name ([parameters])

[] = optionals values.
parameters = They are the data you send from your program to the database

If you are using OLE provider, you can use Stored procedure property when you are creating a connection.

I hope help u


Aldemar