Mega Code Archive
Different ways of calling a procedure with default parameters
<![CDATA[
SQL>
SQL> set serveroutput on
SQL>
SQL> CREATE OR REPLACE PROCEDURE DefaultTest (
2 p_ParameterA NUMBER DEFAULT 10,
3 p_ParameterB VARCHAR2 DEFAULT 'abcdef',
4 p_ParameterC DATE DEFAULT SYSDATE) AS
5 BEGIN
6 DBMS_OUTPUT.PUT_LINE(
7 'A: ' || p_ParameterA ||
8 ' B: ' || p_ParameterB ||
9 ' C: ' || TO_CHAR(p_ParameterC, 'DD-MON-YYYY'));
10 END DefaultTest;
11 /
Procedure created.
SQL> show errors
No errors.
SQL>
SQL> BEGIN
2 DefaultTest(p_ParameterA => 7, p_ParameterC => '30-DEC-95');
3 END;
4 /
END;
*
ERROR at line 3:
ORA-01843: not a valid month
ORA-06512: at line 2
SQL>
SQL> BEGIN
2 DefaultTest(7);
3 END;
4 /
A: 7 B: abcdef C: 19-JUN-2008
PL/SQL procedure successfully completed.
SQL>
SQL>
]]>