RE: Call Stored procedure from another Stored procedure.

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Wed, 13 Jun 2001 08:35:46 -0700
Message-ID: <F001.00327CDD.20010613082036@fatcity.com>

Yes you can; stored procedures would next to useless if you could not. The owner of the calling procedure must have execute privileges on the called procedure. You call a procedure from within a procedure thus

call myprocedure myprocedure;
end call to my procedure

You do not use the SQL*Plus "exec" command when calling a procedure from within another one.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
Sent: Wednesday, June 13, 2001 7:06 AM
To: Multiple recipients of list ORACLE-L

Hi all,

This may have been discussed earlier, but can I call a stored procedure from another stored procedure?

What access must be given to the calling SP to the called SP, and syntax from the calling SP.

TIA
David
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bartolo, David
INET: bartolo_at_USCOLO.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------