Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to call procedure?
Hi,
what are you sending to the database ?
exec works only in sql*plus.
you should be able to execute something anonymous pl/sql blocks like:
begin; my_proc('literal parameter'); end;
BTW, this is what exec does anyway: it wraps your statement into begin/end and sends it to the server.
Karsten
In article <7u5avr$4kl$1_at_newsread.do.de.uu.net>,
"Andreas Reichl" <reichl_at_knuut.de> wrote:
> Hi,
>
> i have the same ( or a similar ) problem.
>
> I want to call a stored procedure from Visual Basic 4
> on Oracle 7 ( NT ). 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( Parameters, ... ).
>
> Andreas Reichl
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 15 1999 - 05:00:10 CDT