create procedure p2
as
begin
 null;
end;
/



create procedure p1()
as
 val varchar2(20);
begin
  select p2() into val from table_name;
end p1;
/