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

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

  1. #1
    Join Date
    Jul 2004
    Posts
    2

    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


    Thanks

  2. #2
    Join Date
    Jul 2004
    Location
    Ludhiana
    Posts
    5
    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.
    Rajesh

  3. #3
    Join Date
    Jul 2004
    Posts
    2

    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