Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Finding out how many rows were updated?
Thanks All,
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:r3m6uvgq33ovk6nspkjik23eb0clqmr0m7_at_4ax.com...
> 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
Received on Mon Dec 22 2003 - 05:18:10 CST