4: (ddl_text in clob) is
5: c integer;
6: rows_processed integer;
7: begin
8: c := dbms_sql.open_cursor;
9: dbms_sql.parse(c, ddl_text, dbms_sql.native);
10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception
5: c integer;
6: rows_processed integer;
7: begin
8: c := dbms_sql.open_cursor;
9: dbms_sql.parse(c, ddl_text, dbms_sql.native);
10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception
13: when others then
6: rows_processed integer;
7: begin
8: c := dbms_sql.open_cursor;
9: dbms_sql.parse(c, ddl_text, dbms_sql.native);
10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception
13: when others then
14: dbms_sql.close_cursor(c);
7: begin
8: c := dbms_sql.open_cursor;
9: dbms_sql.parse(c, ddl_text, dbms_sql.native);
10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception
13: when others then
14: dbms_sql.close_cursor(c);
15: raise;
10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception
13: when others then
14: dbms_sql.close_cursor(c);
15: raise;
16: end apps_ddl;
17: procedure apps_ddl
18: (ddl_text in varchar2) is
18: (ddl_text in varchar2) is
19: c integer;
20: rows_processed integer;
21: begin
22: c := dbms_sql.open_cursor;
23: dbms_sql.parse(c, ddl_text, dbms_sql.native);
24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception
19: c integer;
20: rows_processed integer;
21: begin
22: c := dbms_sql.open_cursor;
23: dbms_sql.parse(c, ddl_text, dbms_sql.native);
24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception
27: when others then
20: rows_processed integer;
21: begin
22: c := dbms_sql.open_cursor;
23: dbms_sql.parse(c, ddl_text, dbms_sql.native);
24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception
27: when others then
28: dbms_sql.close_cursor(c);
21: begin
22: c := dbms_sql.open_cursor;
23: dbms_sql.parse(c, ddl_text, dbms_sql.native);
24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception
27: when others then
28: dbms_sql.close_cursor(c);
29: raise;
24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception
27: when others then
28: dbms_sql.close_cursor(c);
29: raise;
30: end apps_ddl;
31: end APPS_DDL;