Re: problem calling stored procedure

Andreas:

In C++ the trick is to use the implicit begin and end transaction characters :

        sql.Format( "{ exec MyProcedure( var ) }" );

begin; and end; may also work.

good luck
Randy

Andreas Reichl wrote:
>
> Hello,
>
> i have a problem calling a stored procedure on an
> Oracle 7 server (NT) from within a VB4 program
> ( PassThrough mode ).
>
> I have tried several ODBC-Drivers ( Microsoft,
> Oracle ), but i always get an ORA-00900
> ( = "invalid SQL statement" ) - everything else in
> PassThrough mode works.
>
> My Procedure can be called from within SQLPlus
> with
> Exec NameOfProc
> ( no parameters or return value ).
>
> Thanks.
>
> Andreas Reichl
Received on Wed Oct 20 1999 - 13:47:12 CDT