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

Your user-defined domain DATETIME in the output parameter list?



--
With regards,
Thomas Steinmaurer

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php