Parameter Modes
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_OutParameter := 7; -- Legal 11 12 v_LocalVariable := p_InOutParameter; -- Legal 13 14 p_InOutParameter := 7; -- Legal 15 END ModeTest; 16 / Procedure created. SQL> SQL>