SYS.OWA_UTIL dependencies on DBMS_SYS_SQL

Line 59: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

55: found number;
56: begin
57: found := 0;
58: stmt_cursor := dbms_sql.open_cursor;
59: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
60: 'begin
61: select 1
62: into :found
63: from all_tables

Line 92: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

88: found number;
89: begin
90: found := 0;
91: stmt_cursor := dbms_sql.open_cursor;
92: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
93: 'begin
94: select 1
95: into :found
96: from all_views

Line 129: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

125: owner all_synonyms.table_owner%type;
126: db_link all_synonyms.db_link%type;
127: begin
128: stmt_cursor := dbms_sql.open_cursor;
129: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
130: 'begin
131: select table_name, table_owner, db_link
132: into :name, :owner, :db_link
133: from all_synonyms

Line 182: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

178: procname varchar2(255);
179: begin
180: stmt_cursor := dbms_sql.open_cursor;
181: /* resolve name and compose the real package.procedure */
182: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
183: 'declare
184: part1 varchar2(255);
185: part2 varchar2(255);
186: dblink varchar2(255);

Line 241: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

237: else
238: nm := n;
239: end if;
240: stmt_cursor := dbms_sql.open_cursor;
241: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
242: 'select line, text
243: from all_source
244: where name = upper(:n)
245: and owner = upper(:o)

Line 661: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

657:
658: dummy char(1);
659: begin
660: stmt_cursor := dbms_sql.open_cursor;
661: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
662: 'begin
663: dbms_utility.name_tokenize(:cobject,
664: :a, :b, :c, :dblink, :next_pos);
665: end;', dbms_sql.v7);

Line 774: sys.dbms_sys_sql.parse_as_user(col_cursor,

770: col_counter := 0;
771: if (ccolumns = '*')
772: then
773: col_cursor := dbms_sql.open_cursor;
774: sys.dbms_sys_sql.parse_as_user(col_cursor,
775: 'select column_name, data_type, character_set_name '||
776: 'from all_tab_columns '||
777: 'where table_name = :t '||
778: ' and owner = :o '||

Line 840: sys.dbms_sys_sql.parse_as_user(col_cursor,

836: -- remove trailing ',' from col_in_clause
837: col_in_clause := substr(col_in_clause, 1, length(col_in_clause)-1);
838:
839: col_cursor := dbms_sql.open_cursor;
840: sys.dbms_sys_sql.parse_as_user(col_cursor,
841: 'select column_name, data_type, character_set_name, '||
842: 'decode(column_name'||col_decode||') '||
843: 'from all_tab_columns '||
844: 'where table_name = '''||upper(table_resolved)||''' '||

Line 973: sys.dbms_sys_sql.parse_as_user(crsr,

969: col_sizes(i) := NULL;
970: end loop;
971: else
972: crsr := dbms_sql.open_cursor;
973: sys.dbms_sys_sql.parse_as_user(crsr,
974: 'select '||ccolumns||' from '||ctable||' '||cclauses,
975: dbms_sql.v7);
976:
977: for col_counter in 1..nnum_cols

Line 1194: sys.dbms_sys_sql.parse_as_user(table_cursor,

1190: row_count number;
1191: more_rows boolean := TRUE;
1192: begin
1193: table_cursor := dbms_sql.open_cursor;
1194: sys.dbms_sys_sql.parse_as_user(table_cursor,
1195: 'select '||ccolumns||' from '||ctable||' '||cclauses,
1196: dbms_sql.v7);
1197:
1198: for col_counter in 1..nnum_cols

Line 1306: sys.dbms_sys_sql.parse_as_user(cols_cursor,

1302: htp.formHidden('ctable', ctable);
1303: htp.formHidden('COLS', 'DUMMY');
1304:
1305: cols_cursor := dbms_sql.open_cursor;
1306: sys.dbms_sys_sql.parse_as_user(cols_cursor,
1307: 'select column_name from all_tab_columns where table_name = upper(:t)
1308: and owner = upper(:o)',
1309: dbms_sql.v7);
1310: dbms_sql.bind_variable(cols_cursor, ':t', table_resolved);

Line 1867: sys.dbms_sys_sql.parse_as_user( theCursor, theQuery, dbms_sql.native );

1863: raise INVALID_QUERY;
1864: end if;
1865: --
1866: theCursor := dbms_sql.open_cursor;
1867: sys.dbms_sys_sql.parse_as_user( theCursor, theQuery, dbms_sql.native );
1868: --
1869: bv( theCursor, bv1Name, bv1Value );
1870: bv( theCursor, bv2Name, bv2Value );
1871: bv( theCursor, bv3Name, bv3Value );