This procedure will not compile, since it attempts to modify an IN parameter. : Parameter IN « Stored Procedure Function « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Stored Procedure Function
  3. Parameter IN

This procedure will not compile, since it attempts to modify an IN parameter.

   
SQL> CREATE OR REPLACE PROCEDURE IllegalModeIn (p_In IN NUMBER) AS
  2   BEGIN
  3     p_In := 7;
  4   END IllegalModeIn;
  5   /

Warning: Procedure created with compilation errors.

SQL>
SQL>
SQL> show errors
Errors for PROCEDURE ILLEGALMODEIN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/4      PL/SQL: Statement ignored
3/4      PLS-00363: expression 'P_IN' cannot be used as an assignment
         target

SQL>
SQL>








Related examples in the same category

1.Use 'IN' parameters
2.Define in parameter
3.Column type parameter
4.Demonstrate the behavior of IN, OUT, and IN OUT parameter modes.