Re: How can I receive number of rows inserted in PL/SQL?

"Christian Haberbosch" <haberbosch_at_web.de> wrote in message news:2d2929da97a69b432035d8daa5025eb2.30428_at_mygate.mailgate.org...

> I want to have a function like:
> -- the function p1 copies all records from t1 to t2
> -- and returns how many rows have been inserted in t2
> create or replace function p1 return number
> is
> begin
> insert into t2(id) select id from t1;

return SQL%ROWCOUNT;

> end p1;
>

HTH

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam