VB to Oracle Stored Procedures


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: VB to Oracle Stored Procedures

  1. #1
    Dave Guest

    VB to Oracle Stored Procedures


    I am trying to interface a VB app to Oracle calling Oracle Stored procedures.
    The existing VB app interfaces to Sybase in which the stored procedures only
    have input paramters. This works fine returning the SELECt results into an
    ADO recordset.

    Can this work the same way with Oracle ?

    Has anyone managed to or have a code sample of VB calling an Oracle stored
    procedure that only has input parameters and no in/out or output paramters
    ? i.e. I do not want to have to code the Vb the more long winded way of declaring
    command objects and input and output parameters.



    Many Thanks In Advance
    Dave

  2. #2
    Chris Hylton Guest

    Re: VB to Oracle Stored Procedures


    You can execute an Oracle sp w/ just input parameters through a cn.execute
    as far as I know...but, never tried it...but, if you go this route, you won't
    be able to get a recordset back w/ a select statement at the end of your
    SP, Oracle doesn't work that way through the data provider...you have to
    use referential cursors in the Oracle SP in order to get the data back into
    an ADO recordset...and the only way I've gotten that to work is through a
    command object in ADO...and you can use in/out parameters then as well...

    I'd go ahead and convert the code to use the command object...it'll save
    you alot of hassle in the end...and you'll also end up w/ more useful error
    handling if you setup an output error parameter in your SP...

    But, that's just a suggestion...

    Chris

    "Dave" <chippy@totalise.co.uk> wrote:
    >
    >I am trying to interface a VB app to Oracle calling Oracle Stored procedures.
    >The existing VB app interfaces to Sybase in which the stored procedures

    only
    >have input paramters. This works fine returning the SELECt results into

    an
    >ADO recordset.
    >
    >Can this work the same way with Oracle ?
    >
    >Has anyone managed to or have a code sample of VB calling an Oracle stored
    >procedure that only has input parameters and no in/out or output paramters
    >? i.e. I do not want to have to code the Vb the more long winded way of

    declaring
    >command objects and input and output parameters.
    >
    >
    >
    >Many Thanks In Advance
    >Dave



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