-
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
-
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
-
Originally Posted by Mack_DBA
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
The CTXSYS is probably lacking some basic grants.
Look at dba_dependencies to see what is missing.
-
Hello,
we have the same error. Can you help us ?
-
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.
-
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|