--- In firebird-support@yahoogroups.com, Thomas Clarke <thomas.p.clarke@...> wrote:
>
> 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]
>