|
SQL> declare
2
3 Type numberTableType is TABLE OF NUMBER;
4
5 v_numarray numberTableType;
6
7 begin
8
9 if v_numarray IS NULL then
10
11 dbms_output.put_line('v_numarray is null');
12
13 end if;
14
15 v_numarray :=NULL;
16
17 if v_numarray IS NULL then
18
19 dbms_output.put_line('v_numarray is null after assignment');
20
21 end if;
22 end;
23 /
v_numarray is null
v_numarray is null after assignment
PL/SQL procedure successfully completed.
SQL>
|