PL/SQL "Success" Messages [message #37825] |
Fri, 01 March 2002 00:31 |
Emma
Messages: 12 Registered: November 2001
|
Junior Member |
|
|
When you execute transactional sql within a pl/sql function, the output will tell you how many rows sucessfully inserted, updated, deleted etc. How do you then trap this "success" message within your script after execution of block to compare against expected actions.
eg:
update ....... ;
look at how many rows actually updated,
if more than one row updated then;
rollback;
do error message
exit
end;
|
|
|
|