3: procedure apps_ddl (ddl_text in varchar2) is
4: c integer;
5: rows_processed integer;
6: begin
7: c := dbms_sql.open_cursor;
8: dbms_sql.parse(c, ddl_text, dbms_sql.native);
9: rows_processed := dbms_sql.execute(c);
10: dbms_sql.close_cursor(c);
11: exception
4: c integer;
5: rows_processed integer;
6: begin
7: c := dbms_sql.open_cursor;
8: dbms_sql.parse(c, ddl_text, dbms_sql.native);
9: rows_processed := dbms_sql.execute(c);
10: dbms_sql.close_cursor(c);
11: exception
12: when others then
5: rows_processed integer;
6: begin
7: c := dbms_sql.open_cursor;
8: dbms_sql.parse(c, ddl_text, dbms_sql.native);
9: rows_processed := dbms_sql.execute(c);
10: dbms_sql.close_cursor(c);
11: exception
12: when others then
13: dbms_sql.close_cursor(c);
6: begin
7: c := dbms_sql.open_cursor;
8: dbms_sql.parse(c, ddl_text, dbms_sql.native);
9: rows_processed := dbms_sql.execute(c);
10: dbms_sql.close_cursor(c);
11: exception
12: when others then
13: dbms_sql.close_cursor(c);
14: raise;
9: rows_processed := dbms_sql.execute(c);
10: dbms_sql.close_cursor(c);
11: exception
12: when others then
13: dbms_sql.close_cursor(c);
14: raise;
15: end apps_ddl;
16: end APPS_DDL;