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>
|