Re: Number of the rows affected by a SQL statement

Vladimir Konstantinov wrote:
>
> How could i find the number of the rows affected by the last query (within
> stored procedure) ?

Use the SQL%ROWCOUNT cursor variable. This shows the number of rows fetched (not quite what you asked) and the number of rows affected by an Insert , Update or Delete operation.

R.

-- 
_____________________________________________________________

Opinions expressed are my own and do not reflect my employers