Re: How to count the affected number of rows?

[This followup was posted to comp.databases.oracle.server and a copy was sent to the cited author.]

In article <358B198B.8C3C542E_at_hkstar.com>, raycf_at_hkstar.com says...
> 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.
>

Raymond,

After a insert, update, or delete, the number of rows affected can be obtained from slqca.sqlerrd[2].

Regards,
Bob

--

Bob Withers              Do or do not, there is no try.
bwit_at_pobox.com                                  Yoda