BEGIN BEGIN IF NOT (Db_Script_Register_Detail_API.Is_Sub_Section_Registered('COMPONENT', 'MARKET', sub_section_ => 1)) THEN Database_SYS.Reset_Column_Table(columns_); Database_SYS.Set_Table_Column(columns_,'EXAMPLE_ID', 'NUMBER','Y'); Database_SYS.Alter_Table('EXAMPLE_TAB', columns_, TRUE); Db_Script_Register_Detail_API.Register_Sub_Section('COMPONENT', 'MARKET', sub_section_ => 1, 'TRUE', file_name_ => 'MARKET_COMPONENT.cdb'); END IF; EXCEPTION WHEN OTHERS THEN string_ := 'Oratext is: '|| SQLERRM||' >>>'; Db_Script_Register_Detail_API.Register_Sub_Section('MARKET', 'COMPONENT', sub_section_ => 1, 'FALSE', string_, 'MARKET_COMPONENT.cdb'); RAISE; END; / END;