Re: Finding out how many rows were updated?

On 19 Dec 2003 11:51:17 -0800, seaelephant_at_hotmail.com (dx) wrote:

>You can't use sql%rowcount in "returning into" clause.
>
>try this:
>
>UPDATE COMPANIES
>SET CONTACT = p_contact
>WHERE COMPANY_ID = p_CompanyID;
>
>v_noupdated := sql%rowcount;

in Pro*C the sqlca will contain the number of rows processed

--
Sybrand Bakker, Senior Oracle DBA