SQL & PL/SQL

Hi,

i am trying to catch exception for date value in NO_DATA_FOUND.

But looks like, it doesn't work for this date.

select dep_date into v_depDate from Note_Staging where De Note_Id=v_notId;
Exception When NO_DATA_FOUND Then
----
---


But when v_depDate is NULL, it doesn't enter into exception.