-
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
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
|