Pass parameter by data type
SQL>
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>
SQL> BEGIN
2 DefaultTest(7);
3 END;
4 /
A: 7 B: abcdef C: 18-JUN-2008
PL/SQL procedure successfully completed.
SQL>
Related examples in the same category