I agree w/Tom. Use the raise_application_error function when
you want to make the triggering statement fail.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Tuesday, June 19, 2001, 1:59:34 PM, Tom Mercadente wrote:
MTF> While you can use any Oracle supplied function within a check constraint,
MTF> you cannot use a self-written function.
MTF> But you can perform the same thing by using a database table trigger on
MTF> the
MTF> table itself. You can basically validate anything you want from any
MTF> schema
MTF> you wish using a database trigger (with some exceptions).
MTF> A pre-insert trigger on the table would work just fine. Check them out
MTF> in
MTF> the documentation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).