CREATE OR REPLACE PROCEDURE proc1
AS
v_flag VARCHAR2(1):='Y';
BEGIN
IF v_flag != 'Y' THEN
-- call another proc ---
proc2;  
END IF;  

END proc1;

CREATE OR REPLACE PROCEDURE proc2
AS
v_address VARCHAR2(35):= owa_util.GET_CGI_ENV('REMOTE_ADDR');
BEGIN
--update table ---
update USER_ADD set address = v_address;   

END proc2;