Hi everybody,

I am running Oracle 10.2.0.1 database on linux Virtual machine. Running this script as given below, and encountered the problem of

SQL> conn nzdint/nzdint@NZDefInt
Connected.
SQL> @ /home/oracle/Desktop/test.pdc
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at
"CTXSYS.CTX_DOC", line 1478
ORA-06510: PL/SQL: unhandled user-defined
exception
ORA-06512: at "CTXSYS.DRVDISP", line 306
ORA-06510: PL/SQL: unhandled
user-defined exception
ORA-06512: at "CTXSYS.CTX_DOC", line 1478
ORA-06512: at
"CTXSYS.DRVDISP", line 306
ORA-06512: at line 9
User-Defined Exception

PL/SQL procedure successfully completed.

SCRIPT test.pdc
set serveroutput on size 100000
set pagesize 200
declare
-- Local variables here
vbinaryContent BLOB;
vTextContent CLOB;
begin
-- Test statements here
dbms_lob.createtemporary(lob_loc => vTextContent,cache => TRUE);
SELECT content INTO vBinaryContent FROM binary_table;
ctxsys.ctx_doc.ifilter(data=>vBinaryContent,
text=>vTextContent);
INSERT INTO result_table VALUES(vTextContent);
dbms_lob.freetemporary(vTextContent);
EXCEPTION
WHEN OTHERS THEN
IF dbms_lob.istemporary(vTextContent) = 1 THEN
dbms_lob.freetemporary(vTextContent);
END IF;
dbms_output.put_line(dbms_utility.format_error_stack
||dbms_utility.format_error_backtrace
||SQLERRM(SQLCODE));
end;

IF SOMEBODY CAN WORK OUT WHAT's the PROBLEM AND GUIDE ME TO AVOID THIS PROBLEM, WILL BE a GREAT HELP.

Thanks

MACK_DBA