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
