|
SQL>
SQL> set SERVEROUTPUT ON
SQL> Create or replace procedure p_helloTo (i varchar2)
2 is
3 v_string varchar2(256):='Hello, '||i||'!';
4 begin
5 dbms_output.put_line(v_string);
6 end;
7 /
Procedure created.
SQL>
SQL> begin
2 p_helloTo('Everybody');
3 p_helloTo('You');
4 p_helloTo('A');
5 p_helloTo('PL/SQL');
6 end;
7 /
Hello, Everybody!
Hello, You!
Hello, A!
Hello, PL/SQL!
PL/SQL procedure successfully completed.
SQL>
SQL>
|