Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: problem calling stored procedure
From almost two year old memory:
it should be {BEGIN NameofProc; END;}
If you do a list in sqlplus you will see your exec has been replaced by
begin end also.
Hth,
--
Sybrand Bakker, Oracle DBA
Andreas Reichl <reichl_at_knuut.de> wrote in message
news:7uicg7$k36$1_at_newsread.do.de.uu.net...
> 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 Tue Oct 19 1999 - 14:32:24 CDT