SQL>
SQL> CREATE OR REPLACE PROCEDURE hockey_pass (p_person_txt IN VARCHAR2) IS lv_assists_num PLS_INTEGER;
2 BEGIN
3 SELECT 1 INTO lv_assists_num FROM dual;
4 HTP.PRINT(p_person_txt || ' has ' || to_char(lv_assists_num) || ' assists this season');
5 END hockey_pass;
6 /
Procedure created.
SQL>