SYSTEM.WPG_DOCLOAD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 191

    last_updated DATE;

Line: 201

    last_updated_str VARCHAR2(128);

Line: 224

    new_cols := 'LAST_UPDATED,MIME_TYPE,CONTENT_TYPE,DAD_CHARSET,DOC_SIZE';

Line: 234

    sql_stmt := 'select '||new_cols||' from '||p_doctable||
      ' where NAME='''||v_filename||'''';

Line: 238

    dbms_sys_sql.define_column(cursor_handle, 1, last_updated);

Line: 246

    dbms_sys_sql.column_value(cursor_handle, 1, last_updated);

Line: 284

       IF (mod_date = last_updated) THEN
	  IF (mod_len IS NULL OR mod_len = doc_size) THEN
	     last_updated_str := 'NOT_MODIFIED';

Line: 288

	     last_updated_str := to_char(last_updated,
	       'Dy, DD Mon YYYY HH24:MI:SS "GMT"');

Line: 292

	  last_updated_str := to_char(last_updated,
	    'Dy, DD Mon YYYY HH24:MI:SS "GMT"');

Line: 296

       last_updated_str := to_char(last_updated,
	 'Dy, DD Mon YYYY HH24:MI:SS "GMT"');

Line: 303

    p_doc_info := p_doc_info||encode_parameter(last_updated_str);

Line: 315

       last_updated := NULL;

Line: 319

       sql_stmt := 'select '||old_cols||' from '||p_doctable||
	 ' where NAME='''||v_filename||'''';

Line: 334

       p_doc_info := p_doc_info||encode_parameter(last_updated);