I'm new to Oracle and I'm unsure how to use the "ctx_doc.markup" function.
I've tried the example seen here:
428583 but I get the following error:
Error starting at line 6 in command:
declare markedup clob default empty_clob();
begin
ctx_doc.markup(index_name => 'text_index', textkey => '11885', text_query => '{FUZZY({hello},,,W),FUZZY({john},,,W)}', restab => markedup, tagset => 'HTML_DEFAULT');
end;
Error report:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvdoc.reslob_chk
ORA-22275: invalid LOB locator specified
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DOC", line 2198
ORA-06512: at line 3
20000. 00000 - "%s"
*Cause: The stored procedure 'raise_application_error'
was called which causes this error to be generated.
*Action: Correct the problem as described in the error message or contact
the application administrator or DBA for more information.
Note that I've executed this in Oracle SQL Developer's Worksheet
Edit: Also, should I use in-memory or table markup-ing? In-memory seems more performant, though I don't know really know the difference.
Edited by: 981243 on Feb 1, 2013 12:12 AM