Subject Re: Error Message in SP
Author sasidhardoc
...but this executes AND shows the PLAN. Should I use this version? TIA

begin
FOR SELECT PIM_APPOINTMENTS.APPOINTMENT_ID FROM PIM_APPOINTMENTS
WHERE
EXTRACT(MONTH FROM CAST(APPOINTMENT_STARTTIME AS DATE)) =
EXTRACT(MONTH FROM CAST(:DATE_IN AS DATE))
INTO
:DATE_OUT
DO
SUSPEND;
end