Hello World Oracle Procedure.

Creating a Precedure.

CREATE OR REPLACE PROCEDURE skeleton (my_name IN varchar, last_name IN varchar )
IS
BEGIN
DBMS_OUTPUT.PUT_LINE(last_name ||' ' || my_name);
END;

Calling a Precedure.

SET SERVEROUTPUT ON
/
EXECUTE SKELETON('Fawad', 'Nazir')
/