Subject | Re: Error Message in SP |
---|---|
Author | sasidhardoc |
Post date | 2007-04-25T06:14:09Z |
...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
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