Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    New York, U S A

    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


  2. #2
    Join Date
    Feb 2004
    Cali - Colombia

    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts