[firebird-support] SOLVED (was Re: help with stored procedure: SYNTAX error)

[ktadimeti]

--- In firebird-support@yahoogroups.com, "ktadimeti" <tadimetikeshav@...> wrote:
>
> Dear List
> 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)
> Many thanks
>

Thanks Svein and Martjin.
I am slowly picking up Firebird.