oracle markup drsxsopen error

[paulr1984]

Hi!

I'm getting errors whenever I try to call ctx_doc.markup in my stored procedure. Here's my stored procedure:

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',
'<span class=''keyword''>',
'</span>'
);
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. =(