Home » Developer & Programmer » Designer » Oracle Design related
Oracle Design related [message #1137] Wed, 03 April 2002 18:57 Go to next message
Prem Chandran
Messages: 1
Registered: April 2002
Junior Member
I have a bugging problems, I will try to explain

I have to store certain rules in the database as follows

Rule 1: If the name of the person = 'X' and age > 20 and lives in state='Cal' then execute procedure1

Rule 2: If the name of the person = 'X' and age > 20 then execute procedure2

Now when I save a person record, I have to find the rule that would apply to that record and apply it.
i.e. if I save a person record with data as follows

Name ='X' and age = 23 then I have to execute both the procedures ( procedure1 and procedure2).

Now my problem what is the best way to save this rule. please keep in mind this is only a few of the parameters that I have are mentioned here, there can be n number of parameters and there can be n number of rules.

what is the best approach to find which is the rule that I have to apply.
Re: Oracle Design related [message #1146 is a reply to message #1137] Thu, 04 April 2002 04:30 Go to previous message
John R
Messages: 156
Registered: March 2000
Senior Member
If I were you, I'd use a table trigger, probably a Before Insert one.
Previous Topic: R/e Oracle Designer 6i
Next Topic: New Oracle ERD utility, free trial download
Goto Forum:

Current Time: Tue Dec 05 16:56:11 CST 2023