Subject | help with stored procedure: SYNTAX error |
---|---|
Author | ktadimeti |
Post date | 2012-06-08T11:37:37Z |
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
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