49: WHEN OTHERS THEN
50: RETURN;
51: END CSF_LOG; */
52: /*
53: The following procedure drops the index with the help of ad_ddl.do_ddl.
54: */
55: PROCEDURE DROP_INDEX (
56: p_applsys_schema in VARCHAR2 ,
57: p_app_short_name in VARCHAR2 ,
62: )
63: IS
64: BEGIN
65:
66: ad_ddl.do_ddl(
67: applsys_schema => p_applsys_schema,
68: application_short_name => p_app_short_name,
69: statement_type => AD_DDL.DROP_INDEX,
70: statement => 'DROP INDEX ' || p_index ,
65:
66: ad_ddl.do_ddl(
67: applsys_schema => p_applsys_schema,
68: application_short_name => p_app_short_name,
69: statement_type => AD_DDL.DROP_INDEX,
70: statement => 'DROP INDEX ' || p_index ,
71: object_name => p_table
72: );
73:
133: CLOSE index_col_cur ;
134:
135: IF l_create_index THEN
136: DROP_INDEX ( p_applsys_schema, p_app_short_name, p_table, p_index, errbuf, retcode );
137: ad_ddl.do_ddl(
138: applsys_schema => p_applsys_schema,
139: application_short_name => p_app_short_name,
140: statement_type => AD_DDL.CREATE_INDEX,
141: statement => p_create_sql,
136: DROP_INDEX ( p_applsys_schema, p_app_short_name, p_table, p_index, errbuf, retcode );
137: ad_ddl.do_ddl(
138: applsys_schema => p_applsys_schema,
139: application_short_name => p_app_short_name,
140: statement_type => AD_DDL.CREATE_INDEX,
141: statement => p_create_sql,
142: object_name => p_table
143: );
144: