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

There is no switch which will do this, but you can code it in your PL/SQL block. After an update, use SQL%ROWCOUNT to determine how many rows were updated (similarly for insert). Then have your PUT_LINE statement generate the appropriate line.

HTH,
Brian

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.

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam" from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"