using User defined functions in Check constraint

From: Arslan Dar <arslandar_at_skm.org.pk>
Date: Tue, 19 Jun 2001 09:02:48 -0700
Message-ID: <F001.0032EE74.20010619091355@fatcity.com>

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 we press save, registration no. of a patient, gets prefixed with the area code where the patient is being registrered), checks whether the values prefixed with the data are present in a table in another schema, for this purpose we want to use a function(selfmade). This we do to get a unique value irrespective of the area.

If not, is there a work around, to check such a value from a different schema&table in a check constraint. Oracle 8.1.7 on winnt 4
TIA
Hussain
DBA SKMCH & RC Received on Tue Jun 19 2001 - 11:02:48 CDT