Pass parameter by data type : Procedure Call « Stored Procedure Function « Oracle PL / SQL






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

1.Call a stored procedure in a PL/SQL block
2.Call a stored procedure then other statements
3.Dependency Example
4.Forward Declarations
5.Exceptions in Subprograms
6.A PL/SQL procedure with no parameter
7.Exception throwed out of procedure call
8.Default parameter value
9.Calling ParameterLength illegally (ORA-6502)...
10.Use named notation
11.Use named notation, but with a different order of the formal parameters
12.This script demonstrates how to create and call a simple procedure.