# Records inserted

[smsinger3]

Hello all. I am writing a stored procedure and would like to find out if my INSERT statement actually inserted any rows. Sometimes it doesn't because a subquery doesn't select any records. I would think it would look something like this:
IF <fill in here> = 0 then
..no rows were inserted.
END IF;

What would I put for <fill in here>?

Thanks!

SteveS

 

[lewisp]

SQL%ROWCOUNT