Parameter Modes : Parameters « Function Procedure Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Function Procedure Packages
3. Parameters

SQL>
SQL> CREATE OR REPLACE PROCEDURE ModeTest (
  2    p_InParameter    IN NUMBER,
  3    p_OutParameter   OUT NUMBER,
  4    p_InOutParameter IN OUT NUMBER) IS
  5
  6    v_LocalVariable  NUMBER;
  7  BEGIN
  8    v_LocalVariable := p_InParameter;  -- Legal
  9
 10    --p_InParameter := 7;  -- Illegal
 11
 12    p_OutParameter := 7;  -- Legal
 13
 14    --v_LocalVariable := p_outParameter;  -- Illegal
 15
 16    v_LocalVariable := p_InOutParameter;  -- Legal
 17
 18    p_InOutParameter := 7;  -- Legal
 19  END ModeTest;
 20  /

Procedure created.

SQL>
SQL>