Re: need help with PL/SQL Procedure

sven_horn_at_web.de (Sven) wrote in
news:4fbac945.0312100705.1b24037a_at_posting.google.com:

> i try to write a PL/SQL procedure for Oracle 9.2
>
> is there a way to retrieve the number of affected rows of an INSERT or
> an UPDATE statement?
> i tried different ways with RETURNING INTO... but its not working :(
>
> my statement is like:
>
> insert into BEP_EQUIPMENT_CACHE
> (select * from BEP_EQUIPMENT_MV WHERE EQUIPMENT not in (SELECT
> EQUIPMENT FROM BEP_EQUIPMENT_CACHE));
>
> please help,
> thank you all - sven
>

Take a look at SQL%ROWCOUNT

-- 
Ken Denny
http://www.kendenny.com/