CREATE OR REPLACE PROCEDURE PROC_NEW .. AS OLD_PARAM1 VARCAHR2(10); OLD_PARAM2 VARCAHR2(10); OLD................... BEGIN ......... PROC_OLD(OLD_PARAM1 ,OLD_PARAM2 ,OLD.....); ........ END;
create or replace procedure p1 is begin ... end p1; create or replace procedure p2 is begin ... end p2; create or replace prcedure p3 is begin p1; p2; end p3;
..
AS
OLD_PARAM1 VARCAHR2(10);
OLD_PARAM2 VARCAHR2(10);
OLD...................
BEGIN
.........
PROC_OLD(OLD_PARAM1 ,OLD_PARAM2 ,OLD.....);
........
END;
begin
...
end p1;
create or replace procedure p2 is
begin
...
end p2;
create or replace prcedure p3 is
begin
p1;
p2;
end p3;