12 Replies Latest reply: Jul 19, 2012 9:51 AM by 949278 RSS

    CTX_DOC.snippet fails for some files

      Hello everybody,
      I'm performing the following query and it fails for some files.

      myTable myTable
      where myTable.code = :code

      The query works perfectly for 90% of the files and it gives the following error for some of them.

      ORA-20000: Oracle Text error:
      DRG-11207: user filter command exited with status 139

      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.CTX_DOC", line 1297
      ORA-06512: at line 1
      20000. 00000 - "%s"
      *Cause:    The stored procedure 'raise_application_error'
      was called which causes this error to be generated.
      *Action:   Correct the problem as described in the error message or contact
      the application administrator or DBA for more information.

      Could it be that the file is too big? Otherwise I don't have any idea why it doesn't work.
      Could anybody help me, please?
      many many thanks.