create default values : Procedure Parameters « Stored Procedure Function « Oracle PL / SQL






create default values

    
SQL>
SQL>
SQL> create or replace
  2    procedure default_values(
  3    p_parm1 varchar2,
  4    p_parm2 varchar2 default 'default 1',
  5    p_parm3 varchar2 default 'default 2' ) as
  6  begin
  7    dbms_output.put_line( p_parm1 );
  8    dbms_output.put_line( p_parm2 );
  9    dbms_output.put_line( p_parm3 );
 10  end default_values;
 11  /

Procedure created.

SQL>
SQL> exec default_values( 'Tom', p_parm3 => 'Joel' );
Tom
default 1
Joel

PL/SQL procedure successfully completed.

SQL>
SQL> exec default_values( p_parm4 => 'Tom' );
BEGIN default_values( p_parm4 => 'Tom' ); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'DEFAULT_VALUES'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

   
    
    
  








Related examples in the same category

1.Number type parameter
2.create and pass in three parms
3.Store procedure with three parameters
4.positional and named notation for procedure calls.
5.Passing parameter by parameter name
6.Procedure with four parameters
7.First 2 parameters passed by position, the second 2 are passed by name
8.Pass null to procedure
9.Wrong way to reference parameters
10.Procedure with colunm type as parameter type
11.NOCOPY modifier.
12.Legal and illegal formal parameters which are constrained by length.
13.ParameterLength using %TYPE for the parameters(Calling ParameterLength illegally (ORA-6502))
14.Use SYS_REFCURSOR as parameter type
15.Different ways of calling a procedure with default parameters.
16.Default Parameter Values
17.Positional vs. named parameter passing.
18.Use column type to control parameter type
19.Use concatenation to wrap string passed in
20.User-defined collection type parameter