Re: How do get records affected?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 11 Jan 2000 15:15:15 -0500
Message-ID: <4q3n7sg90glkjdsssvbnjq3ofhabqn713d@4ax.com>

A copy of this was sent to "Robert R. Wagner" <expantes_at_maine.rr.com> (if that email address didn't require changing) On Tue, 11 Jan 2000 14:43:10 -0500, you wrote:

>In DBMS_SQL, the EXECUTE function nicely returns the number of records
>affected, which I use a lot.
>
>Now, in a simple procedure using an ordinary UPDATE statement, I want to get
>the number records affected. (Usually, it's just one--I just want to test,
>in order to be sure.) Is there a system variable that yields this?
>

sql%rowcount

right after the UPDATE will tell you.

>
>Thanks >>>>>> Robert
>ExpanTest, Inc.
>22 Monument Square, Suite 503
>Portland, ME 04101-4031
>http://www.gwi.net/expantest
>(207) 871-0224

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jan 11 2000 - 14:15:15 CST