Hi guys. Here's my
problem.
I want to check the
new values (when inserting&updating a table) against the ones in the
existing rows. Something like checking for duplicate values, but using a unique
constraint doesn't suit my needs.
I think of a before
insert&update trigger, wherein checking my condition and raise a error
if not valid. The problem is, in case of an update statement, I get
the mutating "ORA-04091 table <my table> is
mutating....".
I read a lot of doc
but I didn't find any helping ideas. Can you give me some, or maybe a new
approach to this kind of problem?
Thanks in
advance!
iulian
******************************************************************************
The information contained in this communication is confidential and
may be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it. If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking action in
reliance of the contents of this information is strictly prohibited and
may be unlawful. Orange Romania SA is neither liable for the proper,
complete transmission of the information contained in this communication
nor any delay in its receipt.
******************************************************************************
