At 04:14 PM 25/04/2007, you wrote:

>...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

If it works, why not?

It would be interesting to find out why the original version doesn't
work, though. Is that a dialect 1 database? And what is its ODS level?

./heLen