oracle - PL/SQL procedure to cascade delete child tables -

oracle - PL/SQL procedure to cascade delete child tables -

i have situation this.

i have write pl/sql procedure delete kid tables of parent table , modify length of column referenced in kid table.

i need take input user these parameters. parent table name parent column name (whose column size altered ) new column size

i new pl/sql programming .please help me.

thanks in advance.

i'm not going job here, these hints should help you:

find name of primary key constraint of parent table in all_cons_columns table_name='*name of parent table*' , column_name='*name of column want alter*' find kid tables in all_conststraints constraint_type='r' , r_constraint_name='*name of primary key constraint found in step one*' use execute immediate execute dml statements drop kid tables , alter parent table

sql oracle plsql