Re: How do get records affected?

From: <michael_bialik_at_my-deja.com>
Date: Tue, 11 Jan 2000 21:34:07 GMT
Message-ID: <85g7kf$nd8$1@nnrp1.deja.com>

Hi.

Use SQL%ROWCOUNT function to get that info. Check PL/SQL guide for documentation.

HTH. Michael.

In article <KKLe4.6021$Wu6.120636_at_newsr1.maine.rr.com>, "Robert R. Wagner" <RobertWagner_at_alum.mit.edu> 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?
>
> Thanks >>>>>> Robert
> ExpanTest, Inc.
> 22 Monument Square, Suite 503
> Portland, ME 04101-4031
> http://www.gwi.net/expantest
> (207) 871-0224
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 11 2000 - 15:34:07 CST