Named Notation : Function Parameters « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Function Parameters

Named Notation

    

SQL>
SQL>
SQL> CREATE OR REPLACE FUNCTION add_three_numbers(a NUMBER := 0, b NUMBER := 0, c NUMBER := 0 ) RETURN NUMBER IS
  2  BEGIN
  3    RETURN a + b + c;
  4  END;
  5  /

Function created.

SQL>
SQL> BEGIN
  2    dbms_output.put_line(add_three_numbers(c => 4,b => 5,c => 3));
  3  END;
  4  /
  dbms_output.put_line(add_three_numbers(c => 4,b => 5,c => 3));
                       *
ERROR at line 2:
ORA-06550: line 2, column 24:
PLS-00703: multiple instances of named argument in list
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

   
    
    
    
  

Related examples in the same category