DBA Data[Home] [Help]

DDD.APPS_DDL dependencies on DBMS_SQL

Line 8: c := dbms_sql.open_cursor;

4: (ddl_text in varchar2) 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

Line 9: dbms_sql.parse(c, ddl_text, dbms_sql.native);

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

Line 10: rows_processed := dbms_sql.execute(c);

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);

Line 11: 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;

Line 14: dbms_sql.close_cursor(c);

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: end APPS_DDL;