Re: Rows Updated in PL/SQL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 29 Nov 2002 18:47:22 +0100
Message-ID: <uufaia98a25f26@corp.supernews.com>

"Brian Shifflett" <bshifflett_at_brocktool.com> wrote in message news:80938a7d.0211290938.4acb6633_at_posting.google.com...
> how do i display the number of rows that my PL/SQL is updating. the
> only thing displayed is "PL/SQL procedure successfully completed".

dbms_output.put_line(SQL%ROWCOUNT||' updated') *immediately after* the update.
Serveroutput must be on for this

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Fri Nov 29 2002 - 11:47:22 CST