Hi, > Please help me understand where I am going wrong with creating the > following procedure: > > SET TERM ^ ; > > CREATE PROCEDURE TestProc > ( CatName CHAR(15) ) > AS > BEGIN > select cast('Now' as time) as "TIME" from rdb$database; > END^ > > SET TERM ; ^ > > Engine Code : 335544569 > Engine Message : > Dynamic SQL Error > SQL error code = -104 > Token unknown - line 7, column 57 > ; > > Firebird 2.5.1 on Windows (SuperClassic)
A SELECT statement needs an INTO clause (into variables/(output) parameters). With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!