[firebird-support] output from SQL

2012-06-22 Thread ktadimeti
Dear All I wish to output text from a stored procedure. How do I do this? Is there an alternative to the DBMS_OUTPUT package in oracle, or even a simple PRINT statement? Thanks

[firebird-support] help with stored procedure: SYNTAX error

2012-06-08 Thread ktadimeti
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 :

[firebird-support] SOLVED (was Re: help with stored procedure: SYNTAX error)

2012-06-08 Thread ktadimeti
--- In firebird-support@yahoogroups.com, 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

[firebird-support] Re: help with stored procedure: SYNTAX error

2012-06-08 Thread ktadimeti
Thanks Thomas! --- 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