Re: Visual Basic 4 and Stored Procedures

Do at search for "executeSQL method example" in the help file Oracleo.hlp. Here you will see adding
inout/output params to your database object, setting the values of the parameters and then passing the
parameters to the stored procedure in the following style : database.DbExecuteSQL ("Begin stored_procedure_name (:PARAM_NAME1, :PARAM_NAME2); end;")
If one of your paramters is an output type parameter then the result will be passed to it.
the messagebox statement towards the end of the example shows clearly how to access the returned info.

Cheers,
Keith.

Jonathan Gennick <73733.1660_at_compuserve.com> wrote in article <325ef5f0.4943738_at_dub-news-svc-3.compuserve.com>...
> On Tue, 08 Oct 1996 23:16:13 -0500, Todd Verstraten
> <tverstrat_at_tier3.com> wrote:
>
> >the use database.ExecuteSQL('sql statement')
>
> I've always wondered if there is a way to get data back if your stored
> procedure does a select, or generates some output value that you need.
>
> Jonathan
>
Received on Wed Oct 23 1996 - 00:00:00 CEST