DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    ORA-03113: end-of-file on communication error in fulltext search

    i'm using ctxcat for full text in oracle 9i, my frontend application is webbased(in Microsoft.net) the problem is
    that when user input data like (wsdsdfdf|!@#$#$%^$%^&$&*)
    or ('SaturdayMatter|Y''''ahoo|kasldfjlas'''jfl''''aj'''''''''''''''''''''''"""""''''''''''''''''''')
    it give error ORA-03113: end-of-file on communication channel
    it disconnect the application from database, & couldn'y connect to the database untill IIS Server restart.
    and i'm not able to catch this error in stored procedure, whatever i try its useless.
    Plz Help me ASAP

    in sql if i give this then i get this error. i know its 'coz of some characters but how'll i handel it.

    SQL> select c.caseid, c.cname,c.deptid,c.Csummary
    2 from cases c
    3 where CATSEARCH(cname,'wsdsdfdf|!@#$#$%^$%^&$&*',null)>0;
    select c.caseid, c.cname,c.deptid,c.Csummary
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel


  2. #2
    Join Date
    Jul 2004
    when u've made the procedure u forgot to write
    end; line at last
    that's why u r getting this error , end-of-file....

    put the end; on last and try

    All the Best.

    Rajesh Gumber.

  3. #3
    Join Date
    Jul 2004

    error in some strings only

    nops, i've write end in the procedure, this procedure is working fine when i give normal string, its giveing me error in some combinations only, combinations are

    - wsdsdfdf|!@#$#$%^$%^&$&*
    - *&%&%
    - **&%
    and some more.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.