Re: problem calling stored procedure

From: <karsten_schmidt8891_at_my-deja.com>
Date: Wed, 20 Oct 1999 10:03:22 GMT
Message-ID: <7uk416$ste$1@nnrp1.deja.com>

Hi Andreas,
send the statement as anonymous block: begin; my_procedure('parameter'); end;

exec does the same thing in sqlplus.

Karsten

In article <7uicgo$k3r$1_at_newsread.do.de.uu.net>, "Andreas Reichl" <reichl_at_knuut.de> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 20 1999 - 05:03:22 CDT