Retrieving Recordset from Oracle Stored Proc


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Retrieving Recordset from Oracle Stored Proc

  1. #1
    Kermit Goodman Guest

    Retrieving Recordset from Oracle Stored Proc


    The MSDN Knoldegebase article Q176086 -- "HOWTO: Retrieve Recordsets from
    Oracle Stored Procs Using ADO" -- describes how to call a stored prodedure
    that returns several array output prameters to populate an ADO recordset.
    The example, includes the syntax for following the stored procedure:

    QSQL = "{call packperson.oneperson(?,{resultset 2, ssn, fname, lname})}"

    The corresponding procedure signature in the Oracle package is:

    PROCEDURE oneperson
    (onessn IN NUMBER,
    ssn OUT tssn,
    fname OUT tfname,
    lname OUT tlname)
    ...

    When I try to run this code in VB, I am getting an error from Oracle that
    indicates that "ssn" (the first output parameter listed) must be declared
    to Oracle. I did not find in the VB documentation what the names "ssn, fname,
    lname" represent in the procedure call. Do these have to be the same as
    the parameter names in the stored proc? Do they correspond to variables
    in VB?

    Any suggestions for how to get this to work? Any suggested sources for additional
    info. on this?

  2. #2
    Rick O'Hara Guest

    Re: Retrieving Recordset from Oracle Stored Proc


    "Kermit Goodman" <kermit@pobox.com> wrote:
    ...
    >Any suggestions for how to get this to work? Any suggested sources for

    additional
    >info. on this?


    Try www.vboracle.com. They have a tool that you can download, which might
    help you figure this out. I haven't tried it myself yet.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center