IN ORACLE MILIEU …

Some time we face issue about no data found depending on selection criteria. And when this happens in PLSQL procedure we get annoying error ORA-01403: No data found and execution stops. One way to get around this error is to add exception block in our PLSQL procedure as shown below EXCEPTION WHEN NO_DATA_FOUND THEN <Take Action> [...]