Need Help while running script encountered this error

[Mack_DBA]

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

[PAVB]

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.CTX_DOC", line 1478

looks like CTXSYS.CTX_DOC has raised a user defined exception which in not being handled by the code.

Long term solution is to check the code and fix it.
Exception may be caused by bad data, if that's the case fixing the data would be a nice workaround.

[Mack_DBA]

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

[PAVB]

Can you see any other reason, why the same code runs successfully on one machine and on another it shows this error?

Yes.
Different data, data on one server raises an exception while data in the other server doesn't.
Either way, code is not able to handle the raised user defined exception.

[gandolf989]

The CTXSYS is probably lacking some basic grants.
Look at dba_dependencies to see what is missing.

[alaska]

Hello,

we have the same error. Can you help us ?

[gandolf989]

First you need to provide details one the error, perhaps show some sample code that you are running that shows that actual error stack for your problem. Second, this should be a separate post, as it is not related to whatever happened to the original poster.

[alaska]

Thank you. I did a new thread already: see "Reload this Page Error with ctx_doc.ifilter under ORACLE 10.2.0.5". There are sample code and error message.

I hope, it does help you.