893: If csr_doc_exists%found then
894: close csr_doc_exists;
895: --
896: -- Convert document
897: ctx_doc.filter(index_name => l_hr_username || '.IRC_DOCUMENTS_CTX',
898: textkey => l_rowid,
899: restab => clob_doc,
900: plaintext => true);
901: --
974: if (get_schema_name%found) then
975: close get_schema_name;
976: -- Highlight the keywords if highlight string is null
977: if (trim(p_highlight_string) is not null) then
978: CTX_DOC.MARKUP (index_name => l_schema_name||'.IRC_DOCUMENTS_CTX' ,
979: textkey => l_rowid,
980: text_query => p_highlight_string,
981: restab => l_output_clob,
982: plaintext => FALSE,
985: endtag => IRC_MARKUP_ENDTAG);
986:
987: -- IF keyword is null then generate html version without markup
988: else
989: ctx_doc.filter(index_name => l_schema_name||'.IRC_DOCUMENTS_CTX',
990: textkey => l_rowid,
991: restab => l_output_clob,
992: plaintext => false);
993: end if;