Hi

I am trying to create the following SP but am receiving the message "Feature not supported on ODS version older than 11.1" but I cannot work out what it is that it doesn't like about the SP.

For information this is a Firebird 2.1 database but it is an ODS v10

SET AUTODDL OFF;
SET TERM ^ ;

CREATE PROCEDURE SP_LATEST_VACANCY_STATUS (
VACID INTEGER )
RETURNS
(
STAUSNAME VARCHAR(500),
LASTUPDATE DATETIME
)
AS
BEGIN
FOR
SELECT FIRST 1 VST.STATUSNAME, VCH.LASTUPDATE
FROM VACCONT VCO, VACSTATUS VST, VACCONTHIST VCH
WHERE VCO.VACID = :VACID
AND VCO.STATUS = VST.STATUSID
AND VCH.VACID = VCO.VACID
AND VCO.CONTID = VCH.CONTID
AND VCO.STATUS = VCH.STATUS
ORDER BY VCO.STATUS DESC
INTO :STATUSNAME, :LASTUPDATE
DO
SUSPEND;
END
^

SET TERM ; ^
COMMIT WORK;