Table driven stored procedure/SQL invokation

I am trying to write a generic validation engine within Oracle 7 which would be called from a trigger. I would like to put a SQL or PL/SQL block into a table indexed by field type, and then based on the field type, invoke that block.

Example:

field_type     block
emp_no         select count(*) from emp where emp_no=x;
state          select count(*) from states where abbreviation=x

So that when you ran the validation engine, it would look up the appropriate action for the field that you were validating, and take that action.

Any ideas?

Thanks, Ian

-- 


==============================================================

Ian Flint                     |                  iflin_at_ctp.com
                              |                  (415)833-1922


==============================================================