How can I call a stored procedure from another stored procedure in oracle?

Question

can I call a stored procedure from another stored procedure in oracle?give me examples.

Answer 1

Suppose you have two procedures, P_FIRST and P_SECOND and want to call P_SECOND from P_FIRST. The simplest example is this:

create or replace procedure p_first as
begin
  p_second;
end;
/