Calling stored procedures in Oracle stored procedures

Call the stored procedure with exec.

A stored procedure with parameters.
sql> CREATE OR REPLACE PROCEDURE HelloWorld1 (
2 P_user_name VARCHAR2
3) as
4 BEGIN
5 dbms_output.put_line (' Hello ' | | p_user_name | | ‘!‘);
6 END HelloWorld1;
7/

Procedure created.

sql> CREATE OR REPLACE PROCEDURE CallHelloWorld1 (
2 P_user VARCHAR2
3) as
4 BEGIN
5--stored procedure that invokes a stored procedure
6 HelloWorld1 (P_user);
7 END CallHelloWorld1;
8/

Procedure created.

Perform
Sql> set Serveroutput on
sql> exec CallHelloWorld1 (' Tom ');
Hello tom!

PL/SQL procedure successfully completed.

Calling stored procedures in Oracle stored procedures