This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:31 pm, [email protected] wrote: > 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 ==Ticket History== On Mar 07, 2014 @ 03:31 pm, [email protected] wrote: 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; ------ This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/347 [Non-text portions of this message have been removed]
