DBA Data[Home] [Help]

APPS.APPS_DDL dependencies on DBMS_SQL

Line 7: c := dbms_sql.open_cursor;

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

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

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

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

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

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

Line 13: dbms_sql.close_cursor(c);

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;