Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Use the NVL() against a non-initialized BOOLEAN variable

SQL> DECLARE   2       3    my_var BOOLEAN;   4  BEGIN   5       6    IF NOT NVL(my_var,FALSE) THEN   7      dbms_output.put_line('This should happen!');   8    ELSE   9      dbms_output.put_line('This can''t happen!');  10    END IF;  11  END;  12  / This should happen! PL/SQL procedure successfully completed. SQL>