Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL code in constraints?
<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
![]() |
![]() |