Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can dbms_output.put_line reflect sql output/feedback information ?
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