Re: Stored Procs

From: Art <>
Date: Tue, 11 May 1999 06:41:19 -0400
Message-ID: <>

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
the procedure


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


Wolfgang Gey wrote in message <7gp08h$khk$>...
>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

Original text of this message