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
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
On Fri, Jun 22, 2012 at 9:09 AM, ktadimeti tadimetikes...@yahoo.com 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
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
