On Fri, Jun 8, 2012 at 7:37 AM, ktadimeti <tadimetikes...@yahoo.com> 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]
