There is no exception to be raised! When your explict cursor returns no rows you handle this with "EXIT WHEN ..." inside your fetch loop, so there realy is no unhandled exception in your case. If you want to display a message when there is no records returned you should use cursor's ROWCOUNT pseudocolumn outside your loop before you close your cursor:
OPEN InventoryCursor;
LOOP
FETCH InventoryCursor INTO InventoryRow;
EXIT WHEN InventoryCursor%NOTFOUND;
-- ..... other stuff here
END LOOP;
IF InventoryCursor%ROWCOUNT = 0 THEN ....;
END IF;
CLOSE InventoryCursor;
....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?