procedure example 2

--PL/SQL block procedure which accept name and display Hello <name>
CREATE OR REPLACE PROCEDURE prc_msg(sname IN VARCHAR)
IS
BEGIN
    DBMS_OUTPUT.put_line('Hello '||sname);
END prc_msg;
/

DECLARE
    name VARCHAR2(20);
BEGIN
    name:='&name';
    prc_msg(name);
END;
/