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
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.