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

    Unanswered: Passing ADO Recordset to Oracle stored procedure

    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

  2. #2
    Join Date
    Feb 2004
    Location
    Cali - Colombia
    Posts
    16
    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
    A.C.C.

Posting Permissions

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