Hello Community,
I am playing around with Oracle Text using CTX_DOC.markup for some Word documents. But for some Words documents I get the DRG-11225 timeout error and I don't have any idea why.
The index onto the BLOB column is define:
create index "WORD_FILE_IDX_CTX" ON "WORD_FILE" ("WO_FILE") INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('datastore ctxsys.default_datastore filter ctxsys.auto_filter SYNC (EVERY "TRUNC(SYSDATE)+1") TRANSACTIONAL');
Calling the command:
ctx_doc.markup(
index_name => 'word_file_idx_ctx',
textkey => to_char(cur_rec.wo_id),
text_query => l_keywords,
restab => 'word_markup',
query_id => cur_rec.wo_id,
plaintext => FALSE,
tagset => 'HTML_DEFAULT');
Error Message:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_doc.markup
ORA-20000: Oracle Text error:
DRG-11207: user filter command exited with status 2
DRG-11225: Third-party filter timed out.
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.CTX_DOC", line 2252
Thanks for your help.
By the way: How can I markup code over several lines here?
Thanks.
Birthe