Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How many rows were updated ?
Hi Vincent,
Assuming you are using implicit cursors, you can use SQL%ROWCOUNT to get
these results.
Hth,
Sybrand Bakker, Oracle DBA
Vincent GRENET <vincent.grenet_at_free.fr> wrote in message
news:z_on3.53$nd4.307221_at_nnrp1.proxad.net...
> 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 Tue Jul 27 1999 - 16:28:21 CDT