Normalize your application so that tables describe only one type of
objects and do not implement row_type flags. When the design is streamlined
you'll be able to use unique constraints.
> -----Original Message-----
> From: Iulian.ILIES_at_orange.ro [mailto:Iulian.ILIES_at_orange.ro]
> Sent: Tuesday, June 04, 2002 9:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Complex Integrity Checking
>
>
> 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.
> **************************************************************
> ****************
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Iulian.ILIES_at_orange.ro
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
INET: MGogala_at_oxhp.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Jun 04 2002 - 09:38:24 CDT
