SYSTEM.AD_INST dependencies on DBMS_SQL

Line 135: c := dbms_sql.open_cursor;

131: c integer;
132: rows_processed integer;
133: statement varchar2(500);
134: begin
135: c := dbms_sql.open_cursor;
136: statement:='begin '||in_schema||'.apps_ddl.apps_ddl(:ddl_text); end;';
137: dbms_sql.parse(c, statement, dbms_sql.native);
138: dbms_sql.bind_variable(c,'ddl_text',ddl_text);
139: rows_processed := dbms_sql.execute(c);

Line 137: dbms_sql.parse(c, statement, dbms_sql.native);

133: statement varchar2(500);
134: begin
135: c := dbms_sql.open_cursor;
136: statement:='begin '||in_schema||'.apps_ddl.apps_ddl(:ddl_text); end;';
137: dbms_sql.parse(c, statement, dbms_sql.native);
138: dbms_sql.bind_variable(c,'ddl_text',ddl_text);
139: rows_processed := dbms_sql.execute(c);
140: dbms_sql.close_cursor(c);
141: exception

Line 138: dbms_sql.bind_variable(c,'ddl_text',ddl_text);

134: begin
135: c := dbms_sql.open_cursor;
136: statement:='begin '||in_schema||'.apps_ddl.apps_ddl(:ddl_text); end;';
137: dbms_sql.parse(c, statement, dbms_sql.native);
138: dbms_sql.bind_variable(c,'ddl_text',ddl_text);
139: rows_processed := dbms_sql.execute(c);
140: dbms_sql.close_cursor(c);
141: exception
142: when others then

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

135: c := dbms_sql.open_cursor;
136: statement:='begin '||in_schema||'.apps_ddl.apps_ddl(:ddl_text); end;';
137: dbms_sql.parse(c, statement, dbms_sql.native);
138: dbms_sql.bind_variable(c,'ddl_text',ddl_text);
139: rows_processed := dbms_sql.execute(c);
140: dbms_sql.close_cursor(c);
141: exception
142: when others then
143: dbms_sql.close_cursor(c);

Line 140: dbms_sql.close_cursor(c);

136: statement:='begin '||in_schema||'.apps_ddl.apps_ddl(:ddl_text); end;';
137: dbms_sql.parse(c, statement, dbms_sql.native);
138: dbms_sql.bind_variable(c,'ddl_text',ddl_text);
139: rows_processed := dbms_sql.execute(c);
140: dbms_sql.close_cursor(c);
141: exception
142: when others then
143: dbms_sql.close_cursor(c);
144: ad_inst.error_buf := 'do_apps_ddl('||in_schema||','||ddl_text||

Line 143: dbms_sql.close_cursor(c);

139: rows_processed := dbms_sql.execute(c);
140: dbms_sql.close_cursor(c);
141: exception
142: when others then
143: dbms_sql.close_cursor(c);
144: ad_inst.error_buf := 'do_apps_ddl('||in_schema||','||ddl_text||
145: '):'||ad_inst.error_buf;
146: raise;
147: end do_apps_ddl;