On Fri, Jun 8, 2012 at 7:37 AM, 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
>
> Hi there,

Your stored procedure does nothing. If you want to return a time you could
try the following:

SET TERM ^ ;

create or alter procedure TEST_TIME
returns (
the_time time)
as
begin

the_time = Current_Time;

end^

SET TERM ; ^


[Non-text portions of this message have been removed]