-
Error with ctx_doc.ifilter under ORACLE 10.2.0.5
Hello,
the following script
..........................................
declare
temp_clob clob;
begin
for c1 in (select * from output_blob) loop
dbms_lob.createtemporary(temp_clob, true);
ctx_doc.ifilter(c1.text, temp_clob);
dbms_lob.freetemporary(temp_clob);
end loop;
end;
----------------------------------
brings the eror:
--------------------------------------------
FEHLER in Zeile 1:
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 line 12
--------------------------------
Can any body help me ?
-
I moved this thread to the Oracle Database Administration, since it does not belong under how-to. Check to see if the c1.text column is null for any of the rows.
-
The column c1.txt is not null - it contains a txt-file.
Can be a configuration problem, filter-problem ?
The same procedure does unter 10.2.0.4.
-
Originally Posted by alaska
The column c1.txt is not null - it contains a txt-file.
So this query should return zero. Is that correct?
Code:
select count(*) from output_blob where text is null;
-
yes, the output ist count (*) = 0
-
You did not yet post any information about the filter that you created. I'm guessing that without knowing what the filter looks like no one can help you.
Take a look at this.
http://asktom.oracle.com/pls/asktom/...76900346539026
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
|