Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do get records affected?
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
![]() |
![]() |