DBA Data[Home] [Help]

OWAPUB.OWA_UTIL dependencies on DBMS_SYS_SQL

Line 28: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

24: found number;
25: begin
26: found := 0;
27: stmt_cursor := dbms_sql.open_cursor;
28: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
29: 'begin
30: select 1
31: into :found
32: from all_tables

Line 61: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

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

Line 98: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

94: owner all_synonyms.table_owner%type;
95: db_link all_synonyms.db_link%type;
96: begin
97: stmt_cursor := dbms_sql.open_cursor;
98: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
99: 'begin
100: select table_name, table_owner, db_link
101: into :name, :owner, :db_link
102: from all_synonyms

Line 143: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

139: procname varchar2(255);
140: begin
141: stmt_cursor := dbms_sql.open_cursor;
142: /* resolve name and compose the real package.procedure */
143: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
144: 'declare
145: part1 varchar2(255);
146: part2 varchar2(255);
147: dblink varchar2(255);

Line 202: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

198: else
199: nm := n;
200: end if;
201: stmt_cursor := dbms_sql.open_cursor;
202: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
203: 'select line, text
204: from all_source
205: where name = upper(:n)
206: and owner = upper(:o)

Line 557: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

553:
554: dummy char(1);
555: begin
556: stmt_cursor := dbms_sql.open_cursor;
557: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
558: 'begin
559: dbms_utility.name_tokenize(:cobject,
560: :a, :b, :c, :dblink, :next_pos);
561: end;', dbms_sql.v7);

Line 669: sys.dbms_sys_sql.parse_as_user(col_cursor,

665: col_counter := 0;
666: if (ccolumns = '*')
667: then
668: col_cursor := dbms_sql.open_cursor;
669: sys.dbms_sys_sql.parse_as_user(col_cursor,
670: 'select column_name, data_type '||
671: 'from all_tab_columns '||
672: 'where table_name = '''||upper(table_resolved)||''' '||
673: ' and owner = '''||upper(owner_resolved)||''' '||

Line 724: sys.dbms_sys_sql.parse_as_user(col_cursor,

720: -- remove trailing ',' from col_in_clause
721: col_in_clause := substr(col_in_clause, 1, length(col_in_clause)-1);
722:
723: col_cursor := dbms_sql.open_cursor;
724: sys.dbms_sys_sql.parse_as_user(col_cursor,
725: 'select column_name, data_type, '||
726: 'decode(column_name'||col_decode||') '||
727: 'from all_tab_columns '||
728: 'where table_name = '''||upper(table_resolved)||''' '||

Line 849: sys.dbms_sys_sql.parse_as_user(crsr,

845: col_sizes(i) := NULL;
846: end loop;
847: else
848: crsr := dbms_sql.open_cursor;
849: sys.dbms_sys_sql.parse_as_user(crsr,
850: 'select '||ccolumns||' from '||ctable||' '||cclauses,
851: dbms_sql.v7);
852:
853: for col_counter in 1..nnum_cols

Line 1038: sys.dbms_sys_sql.parse_as_user(table_cursor,

1034: row_count number;
1035: more_rows boolean := TRUE;
1036: begin
1037: table_cursor := dbms_sql.open_cursor;
1038: sys.dbms_sys_sql.parse_as_user(table_cursor,
1039: 'select '||ccolumns||' from '||ctable||' '||cclauses,
1040: dbms_sql.v7);
1041:
1042: for col_counter in 1..nnum_cols

Line 1147: sys.dbms_sys_sql.parse_as_user(cols_cursor,

1143: htp.formHidden('ctable', ctable);
1144: htp.formHidden('COLS', 'DUMMY');
1145:
1146: cols_cursor := dbms_sql.open_cursor;
1147: sys.dbms_sys_sql.parse_as_user(cols_cursor,
1148: 'select column_name from all_tab_columns where table_name = upper(:t)
1149: and owner = upper(:o)',
1150: dbms_sql.v7);
1151: dbms_sql.bind_variable(cols_cursor, ':t', table_resolved);

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

1650: raise INVALID_QUERY;
1651: end if;
1652: --
1653: theCursor := dbms_sql.open_cursor;
1654: sys.dbms_sys_sql.parse_as_user( theCursor, theQuery, dbms_sql.native );
1655: --
1656: bv( theCursor, bv1Name, bv1Value );
1657: bv( theCursor, bv2Name, bv2Value );
1658: bv( theCursor, bv3Name, bv3Value );