Thanks Tim.

Before reading your reply I ended up doing the following which is simliar to what you did

c_GenericCursor REFCUR.T_CURSOR;

BEGIN
OPEN c_GenericCursor FOR
SELECT seats_booked
INTO l_fcc_booked
FROM flt_cabin_capacity
WHERE cabin = c_cabin.cabin
AND physical_flight_id = l_physical_flight_id
AND actual_depart_date = l_departure_date;
IF c_GenericCursor%ROWCOUNT = 0 THEN
l_fcc_booked :=0;
END IF;
END;

The way I was doing it with the Begin-Statment-Exception-Statement-End should have worked, but since is was in a Loop-End Loop statement, the In-Line Exception Handling didn't work.

Is there are RESUME NEXT statement in Orcale, where is if there is an exception, handle it, then Resume to the next statement instead of ending the proc? I could not find anything and this is my first time using Oracle.