-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|