Line 597: select EDR_TRANS_QUERY_TEMP_S.nextval into l_query_id from dual;
593: exit;
594: ELSE
595: if (l_count=0) then
596: 597: select EDR_TRANS_QUERY_TEMP_S.nextval into l_query_id from dual; 598: end if;
599: l_count:=l_count+1;
600: dbms_sql.column_value(l_dbms_cur,1,l_document_id);
601: insert into EDR_TRANS_QUERY_TEMP(QUERY_ID,