DBA Data[Home] [Help]

APPS.EDW_MISC_UTIL dependencies on DBMS_SQL

Line 9: l_cid := DBMS_SQL.OPEN_CURSOR;

5: l_cid number;
6: l_dummy number;
7: BEGIN
8:
9: l_cid := DBMS_SQL.OPEN_CURSOR;
10: DBMS_SQL.PARSE(l_cid, ' ALTER SESSION SET global_names = false', DBMS_SQL.NATIVE);
11: l_dummy := DBMS_SQL.EXECUTE(l_cid);
12: DBMS_SQL.CLOSE_CURSOR(l_cid);
13:

Line 10: DBMS_SQL.PARSE(l_cid, ' ALTER SESSION SET global_names = false', DBMS_SQL.NATIVE);

6: l_dummy number;
7: BEGIN
8:
9: l_cid := DBMS_SQL.OPEN_CURSOR;
10: DBMS_SQL.PARSE(l_cid, ' ALTER SESSION SET global_names = false', DBMS_SQL.NATIVE);
11: l_dummy := DBMS_SQL.EXECUTE(l_cid);
12: DBMS_SQL.CLOSE_CURSOR(l_cid);
13:
14:

Line 11: l_dummy := DBMS_SQL.EXECUTE(l_cid);

7: BEGIN
8:
9: l_cid := DBMS_SQL.OPEN_CURSOR;
10: DBMS_SQL.PARSE(l_cid, ' ALTER SESSION SET global_names = false', DBMS_SQL.NATIVE);
11: l_dummy := DBMS_SQL.EXECUTE(l_cid);
12: DBMS_SQL.CLOSE_CURSOR(l_cid);
13:
14:
15: END;

Line 12: DBMS_SQL.CLOSE_CURSOR(l_cid);

8:
9: l_cid := DBMS_SQL.OPEN_CURSOR;
10: DBMS_SQL.PARSE(l_cid, ' ALTER SESSION SET global_names = false', DBMS_SQL.NATIVE);
11: l_dummy := DBMS_SQL.EXECUTE(l_cid);
12: DBMS_SQL.CLOSE_CURSOR(l_cid);
13:
14:
15: END;
16: