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!