Re: Executing stored procedure from another stored procedure.

From: Frank <franjoe_at_frisurf.no>
Date: Mon, 26 Mar 2001 18:26:42 +0200
Message-ID: <85Kv6.1412$NR.102666@news3.oke.nextra.no>

Hi!

Just remove to EXECUTE and leave the calling logic. E.g.
A procedure somewhere called my_proc is simply called by:

...
..
my_proc
..
...

Is this you only problem when porting from Sybase to Oracle? Have you used som clever convertion program? I would like to hear about it ;-)

Frank

Marco van den Hooven <marco_at_vandenhooven.net> wrote in message 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?
>
> Thanks in advance,
>
> Marco van den Hooven
>
>
Received on Mon Mar 26 2001 - 10:26:42 CST