Error with ctx_doc.ifilter under ORACLE 10.2.0.5
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
    3,999
    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.
    this space intentionally left blank

  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
    3,999
    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;
    this space intentionally left blank

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

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    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
    this space intentionally left blank

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