eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

SYSTEM.WPG_DOCLOAD dependencies on DBMS_SYS_SQL

Line 227: cursor_handle := dbms_sys_sql.open_cursor;

223:
224: new_cols := 'LAST_UPDATED,MIME_TYPE,CONTENT_TYPE,DAD_CHARSET,DOC_SIZE';
225: old_cols := 'MIME_TYPE,DOC_SIZE';
226:
227: cursor_handle := dbms_sys_sql.open_cursor;
228:
229: p_doctable := owa_util.get_cgi_env('DOCUMENT_TABLE');
230: IF (p_doctable IS NULL) THEN
231: p_doctable := 'wwv_document';

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

232: END IF;
233:
234: sql_stmt := 'select '||new_cols||' from '||p_doctable||
235: ' where NAME='''||v_filename||'''';
236: dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);
237:
238: dbms_sys_sql.define_column(cursor_handle, 1, last_updated);
239: dbms_sys_sql.define_column(cursor_handle, 2, mime_type, 48);
240: dbms_sys_sql.define_column(cursor_handle, 3, content_type, 128);

Line 238: dbms_sys_sql.define_column(cursor_handle, 1, last_updated);

234: sql_stmt := 'select '||new_cols||' from '||p_doctable||
235: ' where NAME='''||v_filename||'''';
236: dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);
237:
238: dbms_sys_sql.define_column(cursor_handle, 1, last_updated);
239: dbms_sys_sql.define_column(cursor_handle, 2, mime_type, 48);
240: dbms_sys_sql.define_column(cursor_handle, 3, content_type, 128);
241: dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
242: dbms_sys_sql.define_column(cursor_handle, 5, doc_size);

Line 239: dbms_sys_sql.define_column(cursor_handle, 2, mime_type, 48);

235: ' where NAME='''||v_filename||'''';
236: dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);
237:
238: dbms_sys_sql.define_column(cursor_handle, 1, last_updated);
239: dbms_sys_sql.define_column(cursor_handle, 2, mime_type, 48);
240: dbms_sys_sql.define_column(cursor_handle, 3, content_type, 128);
241: dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
242: dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
243:

Line 240: dbms_sys_sql.define_column(cursor_handle, 3, content_type, 128);

236: dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);
237:
238: dbms_sys_sql.define_column(cursor_handle, 1, last_updated);
239: dbms_sys_sql.define_column(cursor_handle, 2, mime_type, 48);
240: dbms_sys_sql.define_column(cursor_handle, 3, content_type, 128);
241: dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
242: dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
243:
244: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);

Line 241: dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);

237:
238: dbms_sys_sql.define_column(cursor_handle, 1, last_updated);
239: dbms_sys_sql.define_column(cursor_handle, 2, mime_type, 48);
240: dbms_sys_sql.define_column(cursor_handle, 3, content_type, 128);
241: dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
242: dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
243:
244: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
245:

Line 242: dbms_sys_sql.define_column(cursor_handle, 5, doc_size);

238: dbms_sys_sql.define_column(cursor_handle, 1, last_updated);
239: dbms_sys_sql.define_column(cursor_handle, 2, mime_type, 48);
240: dbms_sys_sql.define_column(cursor_handle, 3, content_type, 128);
241: dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
242: dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
243:
244: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
245:
246: dbms_sys_sql.column_value(cursor_handle, 1, last_updated);

Line 244: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);

240: dbms_sys_sql.define_column(cursor_handle, 3, content_type, 128);
241: dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
242: dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
243:
244: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
245:
246: dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
247: dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
248: dbms_sys_sql.column_value(cursor_handle, 3, content_type);

Line 246: dbms_sys_sql.column_value(cursor_handle, 1, last_updated);

242: dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
243:
244: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
245:
246: dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
247: dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
248: dbms_sys_sql.column_value(cursor_handle, 3, content_type);
249: dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
250: dbms_sys_sql.column_value(cursor_handle, 5, doc_size);

Line 247: dbms_sys_sql.column_value(cursor_handle, 2, mime_type);

243:
244: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
245:
246: dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
247: dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
248: dbms_sys_sql.column_value(cursor_handle, 3, content_type);
249: dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
250: dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
251:

Line 248: dbms_sys_sql.column_value(cursor_handle, 3, content_type);

244: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
245:
246: dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
247: dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
248: dbms_sys_sql.column_value(cursor_handle, 3, content_type);
249: dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
250: dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
251:
252: dbms_sys_sql.close_cursor(cursor_handle);

Line 249: dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);

245:
246: dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
247: dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
248: dbms_sys_sql.column_value(cursor_handle, 3, content_type);
249: dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
250: dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
251:
252: dbms_sys_sql.close_cursor(cursor_handle);
253:

Line 250: dbms_sys_sql.column_value(cursor_handle, 5, doc_size);

246: dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
247: dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
248: dbms_sys_sql.column_value(cursor_handle, 3, content_type);
249: dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
250: dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
251:
252: dbms_sys_sql.close_cursor(cursor_handle);
253:
254: -- Determine if document has been modified

Line 252: dbms_sys_sql.close_cursor(cursor_handle);

248: dbms_sys_sql.column_value(cursor_handle, 3, content_type);
249: dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
250: dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
251:
252: dbms_sys_sql.close_cursor(cursor_handle);
253:
254: -- Determine if document has been modified
255: mod_since := owa_util.get_cgi_env('HTTP_IF_MODIFIED_SINCE');
256:

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

317: dad_charset := NULL;
318:
319: sql_stmt := 'select '||old_cols||' from '||p_doctable||
320: ' where NAME='''||v_filename||'''';
321: dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);
322:
323: dbms_sys_sql.define_column(cursor_handle, 1, mime_type, 48);
324: dbms_sys_sql.define_column(cursor_handle, 2, doc_size);
325:

Line 323: dbms_sys_sql.define_column(cursor_handle, 1, mime_type, 48);

319: sql_stmt := 'select '||old_cols||' from '||p_doctable||
320: ' where NAME='''||v_filename||'''';
321: dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);
322:
323: dbms_sys_sql.define_column(cursor_handle, 1, mime_type, 48);
324: dbms_sys_sql.define_column(cursor_handle, 2, doc_size);
325:
326: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
327: dbms_sys_sql.column_value(cursor_handle, 1, mime_type);

Line 324: dbms_sys_sql.define_column(cursor_handle, 2, doc_size);

320: ' where NAME='''||v_filename||'''';
321: dbms_sys_sql.parse_as_user(cursor_handle, sql_stmt, dbms_sql.v7);
322:
323: dbms_sys_sql.define_column(cursor_handle, 1, mime_type, 48);
324: dbms_sys_sql.define_column(cursor_handle, 2, doc_size);
325:
326: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
327: dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
328: dbms_sys_sql.column_value(cursor_handle, 2, doc_size);

Line 326: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);

322:
323: dbms_sys_sql.define_column(cursor_handle, 1, mime_type, 48);
324: dbms_sys_sql.define_column(cursor_handle, 2, doc_size);
325:
326: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
327: dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
328: dbms_sys_sql.column_value(cursor_handle, 2, doc_size);
329:
330: dbms_sys_sql.close_cursor(cursor_handle);

Line 327: dbms_sys_sql.column_value(cursor_handle, 1, mime_type);

323: dbms_sys_sql.define_column(cursor_handle, 1, mime_type, 48);
324: dbms_sys_sql.define_column(cursor_handle, 2, doc_size);
325:
326: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
327: dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
328: dbms_sys_sql.column_value(cursor_handle, 2, doc_size);
329:
330: dbms_sys_sql.close_cursor(cursor_handle);
331:

Line 328: dbms_sys_sql.column_value(cursor_handle, 2, doc_size);

324: dbms_sys_sql.define_column(cursor_handle, 2, doc_size);
325:
326: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
327: dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
328: dbms_sys_sql.column_value(cursor_handle, 2, doc_size);
329:
330: dbms_sys_sql.close_cursor(cursor_handle);
331:
332: -- Set the doc_info string

Line 330: dbms_sys_sql.close_cursor(cursor_handle);

326: retval := dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
327: dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
328: dbms_sys_sql.column_value(cursor_handle, 2, doc_size);
329:
330: dbms_sys_sql.close_cursor(cursor_handle);
331:
332: -- Set the doc_info string
333: p_doc_info := encode_parameter(v_filename);
334: p_doc_info := p_doc_info||encode_parameter(last_updated);

Line 346: dbms_sys_sql.close_cursor(cursor_handle);

342:
343: WHEN OTHERS THEN
344: v_filename := NULL;
345: p_doc_info := NULL;
346: dbms_sys_sql.close_cursor(cursor_handle);
347:
348: END get_download_file;
349:
350: --