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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Executing stored procedure from another stored procedure.

Re: Executing stored procedure from another stored procedure.

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: Tue, 27 Mar 2001 13:26:33 +0800
Message-ID: <99qibt$et1$2@news.seed.net.tw>

"Marco van den Hooven" <marco_at_vandenhooven.net> ¼¶¼g©ó¶l¥ó news:99mrpd$uso$1_at_buty.wanadoo.nl...
> Hi all,
>
> After migrating a Sybase database to Oracle 8i, I've a problem with my
> stored procedures.
>
> I've 400+ stored procedures and everyone of them using a line with EXECUTE
> in it, gets rejected by Oracle.
>
> My question:
> What is the right syntax to execute one stored procedure within another? In
> other words what's the Oracle equivalent for the Sybase EXECUTE command?
>

Hi,
just remove the word "EXECUTE". Received on Mon Mar 26 2001 - 23:26:33 CST

Original text of this message

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