NULL VARRAYS and NULL Elements : Varray of Number « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. Varray of Number

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>