Re: VB and Stored Procedures
From: A little left of plumb <dwyche_at_giant.intranet.com>
Date: 1996/11/01
Message-ID: <1996Nov1.132437.16333_at_giant>#1/1
Date: 1996/11/01
Message-ID: <1996Nov1.132437.16333_at_giant>#1/1
In article <55ahr7$djs_at_bcalpha.estec.esa.nl>, mdowning_at_estec.esa.nl (Michael Downing) writes:
>I am trying to run an Oracle stored procedure in a package from Visual Basic 4
>(32 bit).
>I am using SQLpassthrough within ODBC to execute the PL/SQL block, however I
>get nothing returned from the procedure. I think the syntax is correct.
>Can anyone help ? Can you please send example syntax for doing this.
AFAIK, you can't get a PL/SQL procedure to return values using ODBC. It can be done using Oracle Objects for OLE though. There's an example in the OO4O help file under 'ADD Method Example' that'll get you started.
HTH, davidReceived on Fri Nov 01 1996 - 00:00:00 CET