Re: Statement result in a stored procedure

Krzysztof Adamski wrote:
> Hi everybody,
>
> can anybody tell me how can I get result of INSERT, UPDATE or DELETE sql
> statement in a stored procedure? I mean, when I am executing statement
> it gives me some result message, like "0 rows deleted", but how can I
> get this message when I place this statement in a stored procedure?
>
> I would appreciate any advice.
>
> Thanks in advance.
> Krzysiek

Look up SQL%ROWCOUNT in your PL/SQL reference manual.

-- 
Sybrand Bakker
Senior Oracle DBA