|
|
| |
 |
|
A
Generic Cascade Update Procedure
Oracle Tips by Mike Ault |
The Cascade Update Procedures
--
BEGIN
--
-- open and fetch values with cursor
--
OPEN get_table_name;
FETCH get_table_name INTO update_rec;
--
-- now that cursor status is open and values in
-- variables can begin loop
--
LOOP
--
-- using the notfound status we had to pre-populate
-- record
--
EXIT WHEN get_table_name%NOTFOUND;
--
-- Initiate call to the update_column procedure
--
update_column(old_value, new_value, update_rec.table_name,
update_rec.column_name);
--
-- Now get next record from table
--
FETCH get_table_name INTO update_rec;
--
-- processing returns to loop statement
--
END LOOP;
--
-- close cursor and exit
--
CLOSE get_table_name;
--
-- end of procedure
--
END update_tables;
--
-- end of package body
--
END cascade_update;
/
Figure 2: The package containing the procedures
for cascade update
SEE CODE DEPOT FOR FULL SCRIPTS
 |
For more information on this topic, I recommend Don
Burleson's latest book "Oracle
Tuning: The Definitive Reference".
You can buy it direct from the publisher for 50%-off and get
instant access to the code depot of Oracle tuning scripts: |
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|
