The Cascade Update Procedures

               SEE CODE DEPOT FOR FULL SCRIPTS
                --
                dbms_sql.parse(cur,
                'UPDATE '||table_name||' set

'||update_column||'='||chr(39)||new_value||chr(39)||chr(10)||
                SEE CODE DEPOT FOR FULL SCRIPTS
                -- execute the dynamically parsed statement
                --
                rows_processed:=DBMS_SQL.EXECUTE(cur);
                --
                -- close dynamic cursor to prepare for next table
                --
                DBMS_SQL.CLOSE_CURSOR(cur);
--
-- END PROCEDURE
--
END update_column;
 
PROCEDURE update_tables(
                source_table         IN VARCHAR2,
                old_value              IN VARCHAR2,
                new_value            IN VARCHAR2) as
--
-- Create the cursor to read records
-- from bbs_siteid_tables
-- Use * to prohibit missing a column
--
                CURSOR get_table_name IS
                                SELECT
                                                *
                                FROM
                                                bbs_update_tables
                                SEE CODE DEPOT FOR FULL SCRIPTS
--
-- Define rowtype variable to hold record from
-- bbs_siteid_tables. Use rowtype to allow for
-- future changes.
--
                update_rec                update_tables%ROWTYPE;
--
-- start processing
 

SEE CODE DEPOT FOR FULL SCRIPTS

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