Hi!
I'm getting errors whenever I try to call ctx_doc.markup in my stored procedure. Here's my stored procedure:
Code:
function testFunc(anEmpId in varchar2)
return varchar2 is
clMarkedUpText clob;
vSurname varchar2(100);
begin
ctx_doc.markup(
'EMPLOYEE$FREE_TEXT',
anEmpId,
'FOO',
clMarkedUpText,
FALSE,
'HTML_DEFAULT', '', '' );
return 'SUCCESS';
exception
when others then
return sqlerrm;
end testFunc;
Here's the sql statement:
SELECT testFunc(EMP_ID) STOREDPROC_SUCCESS FROM EMPLOYEE
Here's the error message:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drsxsopen
ORA-00904: "SYS_NC00031$": invalid identifier
If I execute the command in toad, the value returned by the function is 'SUCCESS'. If
it is executed within my java application, it returns sqlerrm. The index is created with:
CREATE INDEX EMPLOYEE$FREE_TEXT on EMPLOYEE(XML_COLUMN)
INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('LEXER MYLEXER STOPLIST MYSTOPLIST WORDLIST MYWORDLIST');
FYI: I'm using oracle 10g.
Any help would be appreciated. I haven't got a clue on how to fix this. =(
] 
Blog
Search
Help
Members
Register
Login
Home
