>Dear List
>Please help me understand where I am going wrong with creating the following 
>procedure:
>
>...
>CREATE PROCEDURE TestProc 
>...
>  select cast('Now' as time) as "TIME" from rdb$database;
>...
>Token unknown - line 7, column 57 
>;

What should Firebird do with "TIME"? You simply need an INTO clause and a local 
variable or return parameter before the semicolon.

HTH,
Set

Reply via email to