Re: check how many rows processed of a sql statement

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 06 Jul 1998 14:09:16 GMT
Message-ID: <35a1da39.4429529@192.86.155.100>

A copy of this was sent to dshi_at_magpage.com (David Shi) (if that email address didn't require changing) On 6 Jul 1998 01:07:27 GMT, you wrote:

>Is there a way to check how many rows processed of a sql statement? Thanks.
>
>David

depends on the language.

In C and Pro*C sqlca.sqlerrd[2] has it.

In PL/SQL with 'static' sql, sql%rowcount after an insert/update/delete has it.

In PL/SQL with 'dynamic' sql, dbms_sql.execute returns it as a value...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jul 06 1998 - 09:09:16 CDT