>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