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