Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can dbms_output.put_line reflect sql output/feedback information ?

Can dbms_output.put_line reflect sql output/feedback information ?

From: Wanda Zoe <clarioneer_at_hotmail.com>
Date: Thu, 29 May 2003 15:35:13 +0200
Message-ID: <bb523k$orn$1@newsreader02.ops.uunet.co.za>


At the moment...
SQL> exec sbs.test.func2('ss','ddd');
PL/SQL procedure successfully completed.

I want it to say
SQL> exec sbs.test.func2('ss','ddd');
1 row created
1 row updated
....etc....and then ..
PL/SQL procedure successfully completed.

Currently I'm adding lots of dbms_output information, and this I can view, but i want to add
the actual sql feedback in there as well....

Any help will be appreciated. Received on Thu May 29 2003 - 08:35:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US