Re: Any way to get FEEDBACK on an Anonymous Block?

From: Mike C <michaeljc70_at_hotmail.com>
Date: 8 Jan 2007 17:30:36 -0800
Message-ID: <1168306235.896642.318680@s34g2000cwa.googlegroups.com>

Mark D Powell wrote:
> sybrandb wrote:
> > Mike C wrote:
> > > Is there anyway to get automatic FEEDBACK (like 8 rows updated, etc.)
> > > on commands in an Anonymous block in a SQL*Plus script?
> >
> > SQL%ROWCOUNT has the number of records selected or updated, or inserted
> > or deleted.
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Mike, %ROWCOUNT is known as a cursor attribute. Look this term up in
> the index of your PL/SQL User Guide and Reference for others and for
> finding details on using them.
>
> HTH -- Mark D Powell --

I understand that....that is not automatic though...I would have to add a PUT_LINE for every SELECT/UPDATE/INSERT of which there are many. Received on Mon Jan 08 2007 - 19:30:36 CST