Re[2]: using User defined functions in Check constraint

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, T

RE: using User defined functions in Check constraint

Title: using User defined functions in Check constraint Hussain While you can use any Oracle supplied function within a check constraint, you cannot use a self-written function.  But you can perform the same thing by using a database table trigger on the table itself.  You can basically

using User defined functions in Check constraint

Title: using User defined functions in Check constraint Hello All Can we use user made functions in the check constraints?. Like In the check constraitns, we can use oracle functions, like LENGTH(NAME)=9. What we want to do is to check a value, which before being saved in the database(when