Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL code in constraints?

Re: PL/SQL code in constraints?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 30 May 2005 10:28:30 -0400
Message-ID: <x42dnXdSBrOIvgbfRVn-tw@comcast.com>

<sybrandb_at_yahoo.com> wrote in message
news:1117457271.685833.3600_at_g47g2000cwa.googlegroups.com...
> Constraints signify relationships between entities.
> Consequently it is not possible to add any procedural logic.
> You'll need to use triggers.
> However note, you should avoid replacing constraints completely by
> triggers.
> Enforcing integrity by means of triggers is about 8 times slower.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>

The OP may have been refering to CHECK constraints, which may seem to provide an opportunity for PL/SQL calls. However, a specific restriction on CHECK constraints is that they cannot call user-defined functions.

++ mcs Received on Mon May 30 2005 - 09:28:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US