SYS.WPG_DOCLOAD dependencies on DBMS_SYS_SQL

Line 229: cursor_handle := sys.dbms_sys_sql.open_cursor;

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

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 241: sys.dbms_sys_sql.define_column(cursor_handle, 1, last_updated);

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);
244: sys.dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
245: sys.dbms_sys_sql.define_column(cursor_handle, 5, doc_size);

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

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);
244: sys.dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
245: sys.dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
246: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);

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

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);
244: sys.dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
245: sys.dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
246: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);
247:

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

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);
244: sys.dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
245: sys.dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
246: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);
247:
248: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);

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

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);
244: sys.dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
245: sys.dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
246: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);
247:
248: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
249:

Line 246: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);

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);
244: sys.dbms_sys_sql.define_column(cursor_handle, 4, dad_charset, 256);
245: sys.dbms_sys_sql.define_column(cursor_handle, 5, doc_size);
246: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);
247:
248: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
249:
250: sys.dbms_sys_sql.column_value(cursor_handle, 1, last_updated);

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

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

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

246: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);
247:
248: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
249:
250: sys.dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
251: sys.dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
252: sys.dbms_sys_sql.column_value(cursor_handle, 3, content_type);
253: sys.dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
254: sys.dbms_sys_sql.column_value(cursor_handle, 5, doc_size);

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

247:
248: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
249:
250: sys.dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
251: sys.dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
252: sys.dbms_sys_sql.column_value(cursor_handle, 3, content_type);
253: sys.dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
254: sys.dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
255:

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

248: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
249:
250: sys.dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
251: sys.dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
252: sys.dbms_sys_sql.column_value(cursor_handle, 3, content_type);
253: sys.dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
254: sys.dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
255:
256: sys.dbms_sys_sql.close_cursor(cursor_handle);

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

249:
250: sys.dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
251: sys.dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
252: sys.dbms_sys_sql.column_value(cursor_handle, 3, content_type);
253: sys.dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
254: sys.dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
255:
256: sys.dbms_sys_sql.close_cursor(cursor_handle);
257:

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

250: sys.dbms_sys_sql.column_value(cursor_handle, 1, last_updated);
251: sys.dbms_sys_sql.column_value(cursor_handle, 2, mime_type);
252: sys.dbms_sys_sql.column_value(cursor_handle, 3, content_type);
253: sys.dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
254: sys.dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
255:
256: sys.dbms_sys_sql.close_cursor(cursor_handle);
257:
258:

Line 256: sys.dbms_sys_sql.close_cursor(cursor_handle);

252: sys.dbms_sys_sql.column_value(cursor_handle, 3, content_type);
253: sys.dbms_sys_sql.column_value(cursor_handle, 4, dad_charset);
254: sys.dbms_sys_sql.column_value(cursor_handle, 5, doc_size);
255:
256: sys.dbms_sys_sql.close_cursor(cursor_handle);
257:
258:
259: -- Determine if document has been modified
260: mod_since := owa_util.get_cgi_env('HTTP_IF_MODIFIED_SINCE');

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);

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

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);
339:
340: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);

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

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);
339:
340: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
341: sys.dbms_sys_sql.column_value(cursor_handle, 1, mime_type);

Line 338: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);

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);
339:
340: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
341: sys.dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
342: sys.dbms_sys_sql.column_value(cursor_handle, 2, doc_size);

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

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);
339:
340: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
341: sys.dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
342: sys.dbms_sys_sql.column_value(cursor_handle, 2, doc_size);
343:
344: sys.dbms_sys_sql.close_cursor(cursor_handle);

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

337: sys.dbms_sys_sql.define_column(cursor_handle, 2, doc_size);
338: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);
339:
340: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
341: sys.dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
342: sys.dbms_sys_sql.column_value(cursor_handle, 2, doc_size);
343:
344: sys.dbms_sys_sql.close_cursor(cursor_handle);
345:

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

338: sys.dbms_sys_sql.bind_variable(cursor_handle, ':docname', v_filename);
339:
340: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
341: sys.dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
342: sys.dbms_sys_sql.column_value(cursor_handle, 2, doc_size);
343:
344: sys.dbms_sys_sql.close_cursor(cursor_handle);
345:
346: -- Set the doc_info string

Line 344: sys.dbms_sys_sql.close_cursor(cursor_handle);

340: retval := sys.dbms_sys_sql.execute_and_fetch(cursor_handle,TRUE);
341: sys.dbms_sys_sql.column_value(cursor_handle, 1, mime_type);
342: sys.dbms_sys_sql.column_value(cursor_handle, 2, doc_size);
343:
344: sys.dbms_sys_sql.close_cursor(cursor_handle);
345:
346: -- Set the doc_info string
347: p_doc_info := encode_parameter(v_filename);
348: p_doc_info := p_doc_info||encode_parameter(last_updated);

Line 360: sys.dbms_sys_sql.close_cursor(cursor_handle);

356:
357: WHEN OTHERS THEN
358: v_filename := NULL;
359: p_doc_info := NULL;
360: sys.dbms_sys_sql.close_cursor(cursor_handle);
361:
362: END get_download_file;
363:
364: --