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>