Subject Rollback event on trigger
Author Adomas Urbanavicius
Hi,
Is it possiple somehow to rollback edit/delete/insert event on trigger
automatically ?
I can raise ecxeption, but what if I want to do it silently.
Something like
table tb_cutomers

trigger on delete
..... test if customer has some not returned loans ..... then
rollback/cancel
else delete it.

It is possible to do so in App, but some "clever" customers admins can
access raw table via console and write "delete from tb_customers...." :))
Same with edition or insertion.




Adomas