|
SQL>
SQL> declare
2 Type numberTableType is TABLE OF NUMBER;
3 v_emptyarray numberTableType :=numberTableType();
4 begin
5 if v_emptyarray IS NULL then
6 dbms_output.put_line('v_emptyarray is null');
7 else
8 dbms_output.put_line('v_emptyarray is NOT null');
9 end if;
10 end;
11 /
v_emptyarray is NOT null
PL/SQL procedure successfully completed.
SQL>
|