Hi.

I guess he meant this type of thing, but got lost in the moment:

Code:
PROCEDURE .......
  CURSOR c IS
    SELECT seats_held
      FROM flt_cabin_capacity
     WHERE cabin = c_cabin.cabin
       AND physical_flight_id = l_physical_flight_id
       AND actual_depart_date = l_departure_date;
BEGIN
  OPEN c;
  FETCH c INTO l_fcc_held;
  IF c%NOTFOUND THEN
      l_fcc_held := 0;
  END IF:
  CLOSE c;
-- Procedure Continues here...
END;
Cheers

Tim...