Re: How to count the affected number of rows?

From: <saropani_at_my-dejanews.com>
Date: Mon, 22 Jun 1998 05:22:24 GMT
Message-ID: <6mkpmf$a6l$1@nnrp1.dejanews.com>

In article <358B198B.8C3C542E_at_hkstar.com>, Raymond Li <raycf_at_hkstar.com> wrote:
>
> Hello,
> I am using Pro*C to call an update statement. After that, I assure
> the call success by examining the sqlca.sqlcode equal to zero.
>
> But how can I know how many rows are updated?
>
> Thanks in advance for your answers.
>
> Regards,
> Raymond Li
> http://www.planet.net.hk/~supercat
>

Hi Raymond,

Did you try using SQL%ROWCOUNT to find the affected rows? If you are using a PL/SQL block this is possible.

Regards,
Saravanan

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 22 1998 - 00:22:24 CDT