SQL> SET ServerOutput Onsql> Create or Replace Procedure Test1 (i in number) AS 2 Begin 3 dbms_output.put_line ('Enter parameter is' || to_CHAR (i)); 4 end; 5 /
The process has been created.
SQL> EXECUTE TEST1 (9825); input parameters are 9825
The PL / SQL process has been successfully completed.
