Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How many rows were updated ?
SQL%ROWCOUNT
Vincent GRENET wrote:
> Hi all.
>
> In an stored procedure, how can I know how many rows were updated by an
> update statement ? I've seen in the PRO*C precompiler documentation that I
> can find that information in the sqlca area. But I did not see anything like
> that in the SQL or PL/SQL documentation.
>
> Or can I know if any row was updated ? Same question for a delete.
>
> Vincent
Received on Wed Jul 28 1999 - 06:53:33 CDT