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 -> Re: Can dbms_output.put_line reflect sql output/feedback information ?

Re: Can dbms_output.put_line reflect sql output/feedback information ?

From: Agis Stamatopoulos <stag_at_hq.acn.gr>
Date: Thu, 29 May 2003 16:33:49 +0300
Message-ID: <3ED60C3D.6050803@hq.acn.gr>


I think that it can not be done since you use pl/sql because you take the output from the server.

Wanda Zoe wrote:
> 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:33:49 CDT

Original text of this message

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