Solving a certain type of business rules in the Oracle database
ABSTRACT
In this article, it is shown how to avoid the problem of a so-called “vicious cycle” (closed loop) in data with tree structure by doing that completely on the data base side, without writing any client software or application server software.
Single user and multi user solution is given. In multi user solution, our simulation of “ROLLBACK TO SAVEPOINT feature” is used in data base trigger, which involve quasi-remote procedures (it means that local procedures has been called like they are from some other data base).