Is Table Driven Logic possible?

From: <dejaron_at_my-dejanews.com>
Date: Wed, 12 Aug 1998 19:08:47 GMT
Message-ID: <6qsp7v$8sl$1@nnrp1.dejanews.com>

Can you set up tables for use on Oracle to perform table-driven logic? For example, have a table populated as:

action     procedure_name
------     --------------
add        test_proc1
add        test_proc2
change     test_proc50
change     test_proc51
change     test_proc60
delete     test_proc1
delete     test_proc60

and then perform a SELECT where action = 'add' and use all occurrences of the field procedure_name to call that procedure name stored in the field itself. So that I could then call test_proc1 and test_proc2 without actually knowing the procedures names (since they're in a table)?

Any help would be greatly appreciated.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 12 1998 - 14:08:47 CDT