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
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
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: [EMAIL PROTECTED]
Fat
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
/nlzanen1/External/MEY/NL)
O.edu Subject: Call Stored procedure from
another Stored procedure.
Sent by:
[EMAIL
Let say you have my_procedure1 (param1 IN VARCHAR, param2 OUT VARCHAR);
In procedure2 code you could write:
PROCEDURE my_procedure2 AS
par_1 VARCHAR2(10) := My Test;
par_2 VARCHAR2(5);
BEGIN
my_procedure1(par_1, par_2);
DBMS_OUTPUT.PUT_LINE(par_2);
-- etc
END;
HTH
