The Cascade Update Procedures

CREATE OR REPLACE PACKAGE BODY cascade_update AS

PROCEDURE update_column(
                old_value              IN VARCHAR2,
                new_value            IN VARCHAR2,
                table_name           IN VARCHAR2,
                update_column   IN VARCHAR2)
AS
--
-- define state variables for dbms_sql procedures
--
                cur                          INTEGER;
                rows_processed                 INTEGER;
--
-- start processing
-- (dbms_output calls are for debugging
-- commented out during normal runtime)
--
BEGIN
--                DBMS_OUTPUT.PUT_LINE('Table name:
'||table_name||' Column: '||update_column);
                --
                -- initialize the dynamic cursor location for
                -- the dbms_sql process
                --
                cur:=DBMS_SQL.OPEN_CURSOR;
                --
                -- populate the initialized location with the
statement to be
                -- processed
                --
--                DBMS_OUTPUT.PUT_LINE(
--                'UPDATE '||table_name||' set '||update_column||'='||chr(39)||new_value||chr(39)||chr(10)||

SEE CODE DEPOT FOR FULL SCRIPTS

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm