Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How many rows were updated ?

Re: How many rows were updated ?

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Wed, 28 Jul 1999 07:53:33 -0400
Message-ID: <379EEF3D.C4C50F64@Unforgettable.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US