can we call stored procedure inside stored procedure?

Question

Please explain this one, can we call stored procedure inside stored procedure ?

This seems to come up a lot, e.g. https://stackoverflow.com/q/38842882/230471 I wonder if there is any programming language that does not allow this? — William Robertson, Dec 11 '19 at 22:01

score 0 · Answer 1 · answered Dec 10 '19 at 06:15

0

Sure, why not. Suppose there are two procedures, proc_a and proc_b.

create or replace procedure proc_a is
begin
  proc_b;          --> this is how you call proc_b from proc_a
end;
/

answered Dec 10 '19 at 06:15

Littlefoot

1 Answers1