Need Help while running script encountered this error
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
Need Help : while running this script encountered this error
Hi PAVB,
Thanks for your response. However, the same script on another server is running without any problems. The another server I am mentioning , has the same configuraton. So, it is bit hard to accept your argument that "code needs to be fixed"
Can you see any other reason, why the same code runs successfully on one machine and on another it shows this error?
Look forward for somemore adivce from you.
Regards,
Mack_DBA