| Oracle Design related [message #1137] |
Wed, 03 April 2002 18:57  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
