Re: Stored Procs

Hi, Wolfgang
Here is some information may help:

'If the procedure is my_proc(in, out),

Dim qy As rdoQuery
Dim in_val

Set qy = cn.CreateQuery("", "{call my_proc(?,?)}")

    qy.rdoParameters(0).Direction = rdParamInput
    qy.rdoParameters(1).Direction = rdParamOutput
    qy.rdoParameters(0).Value = in_val           'pass the parameter(in) to

    qy.Execute

'you can get the parameter(out) using: qy.raoParameters(1).value

Art

Wolfgang Gey wrote in message <7gp08h$khk$1_at_news.cs.tu-berlin.de>...
>Could somebody tell me how I can call an oracle stored procedure in visual
>basic embedded SQL,
>after connecting with ODBC?
>Unfortunately are comments the books very rare in this respect.
>Thanks for alerting this problem!
>
>
Received on Tue May 11 1999 - 12:41:19 CEST