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





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

1.Pass value to function parameter
2.Boolean value function parameter
3.The FullName Function
4.A stored function with no parameters.
5.Use Column type as the function parameter type
6.Varray type parameter
7.Clob type parameter
8.Positional Notation
9.Get circle area
10.Pass number value to function
11.Mixed Name and Position Notation Calls