have a procedure that executes succesfully in Firebird 2.0.1.
However, on trying to see the PLAN , I get an error. Please see below
START_TIME is a TimeStamp column
------------
CREATE PROCEDURE P_TESTING (
DATE_IN TimeStamp)
returns (
DATE_OUT Integer)
AS

begin
FOR SELECT PIM_APPOINTMENTS.APPOINTMENT_ID FROM PIM_APPOINTMENTS
WHERE
EXTRACT(MONTH FROM APPOINTMENT_STARTTIME) = EXTRACT(MONTH FROM :DATE_IN)
INTO
:ID_OUT
DO
SUSPEND;
end
------------------
ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -105
Specified EXTRACT part does not exist in input datatype