Hi everyone,
I've a stored procedure which have a
EXCEPTION WHEN NO_DATA_FOUND THEN code in it, but it seems like the EXCEPTION is not working as the msg I put doesn't display at all... here is the code:

PROCEDURE UpdateInventoryCurrPrice
(nItemId IN NUMBER) IS
CURSOR InventoryCursor IS
SELECT ItemSize, InvId, Curr_Price FROM Inventory
WHERE ItemId = nItemId ORDER BY ItemSize;
InventoryRow InventoryCursor%ROWTYPE;
BEGIN
OPEN InventoryCursor;
LOOP
FETCH InventoryCursor INTO InventoryRow;
EXIT WHEN InventoryCursor%NOTFOUND;
-- ..... other stuff here
END LOOP
EXCEPTION WHEN NO_DATA_FOUND THEN
TEXT_IO.PUT_LINE ('No data returned for this ItemId ' ||
nItemId);
END;

How come I cannot see the msg, even I know the value I pass in is not inside the table... can someone pls. help me?

Thanks.
Regards,
Wai Chong