DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Error with ctx_doc.ifilter under ORACLE 10.2.0.5

  1. #1
    Join Date
    Jun 2012
    Posts
    5

    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 ?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

  3. #3
    Join Date
    Jun 2012
    Posts
    5
    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.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by alaska View Post
    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;

  5. #5
    Join Date
    Jun 2012
    Posts
    5
    yes, the output ist count (*) = 0

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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
  •  


Click Here to Expand Forum to Full Width