Re: need help with PL/SQL Procedure

Also, make sure it is the statement immediately following the DML command otherwise you lose its value (especially if it is an explicit cursor and you close the cursor ;)
"Ken Denny" <ken_at_kendenny.com> wrote in message news:Xns944D68D419FCCkendenny_at_216.77.188.18...
> 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/
Received on Wed Dec 10 2003 - 16:30:40 CET