Mega Code Archive
MyProc procedure with a default value for both parameters
<![CDATA[
SQL> CREATE OR REPLACE PROCEDURE myProc(ip_line_length IN NUMBER DEFAULT 50,ip_separator IN VARCHAR2 DEFAULT '=')
2 IS
3
4 myString VARCHAR2(150);
5
6 BEGIN
7
8 FOR idx in 1..ip_line_length LOOP
9
10 myString :=myString ||ip_separator;
11
12 END LOOP;
13
14 DBMS_OUTPUT.PUT_LINE(myString);
15
16 EXCEPTION WHEN OTHERS THEN
17 dbms_output.put_line(SQLERRM);
18 END;
19 /
Procedure created.
SQL>
]]>