Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to call procedure?

Re: how to call procedure?

From: <karsten_schmidt8891_at_my-deja.com>
Date: Fri, 15 Oct 1999 10:00:10 GMT
Message-ID: <7u6tv5$8e9$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US