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
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 :
--- 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
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