Re: [firebird-support] output from SQL

2012-06-22 Thread Milan Babuskov
ktadimeti wrote: > I wish to output text from a stored procedure. How do I do this? There are different way, depending what you really need: 1. You can create a selectable stored procedure: create procedure p1 returns (output_text varchar(3000)) as begin for select something into :output_text do

Re: [firebird-support] output from SQL

2012-06-22 Thread Ann Harrison
On Fri, Jun 22, 2012 at 9:09 AM, ktadimeti wrote: > > 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? > You need to display the text from the client, not the stored procedure whi

Re: [firebird-support] output from SQL

2012-06-22 Thread Tomasz Tyrakowski
On 2012-06-22 14:09, ktadimeti wrote: > 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? I'm not sure I understood you correctly, but you can just select rows from a "selectable" s

[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