Try to check sql%rowcount. It shows the number of rows have been processed
by last sql statement
Hope this will help
SJ> Hi
SJ> I have a stored procedure which updates a table. How can I find out
SJ> whether the update was successful or whether zero rows were inserted?
SJ> SQLPlus usually prints out the amount of rows updated. I would like
SJ> to get a similar information in my stored procedure.
SJ> I'm using Oracle 8.0.5 for Linux.
SJ> bye
SJ> --
SJ> Sam Jordan
Received on Thu Jun 03 1999 - 03:29:02 CDT
