I am getting ora-03113 with .net as front end.
I have to send 4000 id's to a "select" statement from front end. I know i have to use "IN" option in my select statement. But "IN" doesnot support for more than 1000 ids. So I created a table(X) and inserted all 4000 ids into table and i used
"SELECT .. FROM .. WHERE id IN (SELECT id FROM X)". I tested my procedure from sql editor. IT WORKS FINE.
But same procedure if i call from front end .NET i am getting error like
" ORA-03113 end-of-file on communication channel ". and it not at all hitting the my procedure.
I am looking for some ones help. Or Please let me know if any better way to handle 4000 ids to select satement.
I will really appreciate your help.