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|!@#$#$%^$%^&$&*)
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
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.
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
and some more.
Click Here to Expand Forum to Full Width