|
SQL>
SQL> declare
2 Type numberVarray is VARRAY(5)OF NUMBER;
3 v_numvarray numberVarray;
4 begin
5
6 if v_numvarray IS NULL then
7 dbms_output.put_line('v_numvarray is null');
8 end if;
9
10 v_numvarray :=NULL;
11
12 if v_numvarray IS NULL then
13 dbms_output.put_line('v_numvarray is null after assignment');
14 end if;
15 end;
16 /
v_numvarray is null
v_numvarray is null after assignment
PL/SQL procedure successfully completed.
SQL>
|