I believe you can do this without too much difficulty. You have to
explicitly allocate a cursor, read the contents of the column, parse it,
then execute it, then repeat. Look in the PL/SQL documentation on dynamic
SQL.
Good luck,
Dave
dejaron_at_my-dejanews.com wrote in message
<6qsp7v$8sl$1_at_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 - 21:34:46 CDT
