DBA Data[Home] [Help]

SYS.WPG_DOCLOAD dependencies on DBMS_SQL

Line 239: sys.dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);

235:
236: sql_stmt := 'select '||new_cols||' from '||dbms_assert.qualified_sql_name(p_doctable)||
237: ' where NAME=:docname';
238:
239: sys.dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);
240:
241: sys.dbms_sys_sql.define_column(cursor_handle, 1, last_updated);
242: sys.dbms_sys_sql.define_column(cursor_handle, 2, mime_type, 48);
243: sys.dbms_sys_sql.define_column(cursor_handle, 3, content_type, 128);

Line 334: sys.dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);

330:
331: sql_stmt := 'select '||old_cols||' from '||
332: dbms_assert.qualified_sql_name(p_doctable) ||
333: ' where NAME=:docname';
334: sys.dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);
335:
336: sys.dbms_sys_sql.define_column(cursor_handle, 1, mime_type, 48);
337: sys.dbms_sys_sql.define_column(cursor_handle, 2, doc_size);
338: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);