VB to Oracle Stored Procedures

[Dave]

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

[Chris Hylton]

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