?
Solved

ORA-03113 end-of-file  in .net

Posted on 2003-03-07
4
Medium Priority
?
877 Views
Last Modified: 2013-12-12
Hi,

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.

Regards,
venkat.
0
Comment
Question by:venkateswarlu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 8

Expert Comment

by:Danielzt
ID: 8091549
Please read these:

(pay attehtion to the first two,if works, please let me know.)
http://www.oracledba.co.uk/tips/817_subqueries.htm
http://home.clara.net/dwotton/dba/ora3113.htm


http://www.experts-exchange.com/Databases/Oracle/Q_20295868.html

http://www.oracle-error.com/ora-03113.htm

http://www.dbaoncall.net/cgi-bin/ikonboard/topic.cgi?forum=1&topic=107

ORA-03113 means "end-of-file on communication channel"
It is not the problem of Oracle database or listener.
Most likely it is caused by the configuration of you network and server.

For example, on our site we have one server that is configured it that way: any user connection to the Unix box get killed if it is not active for 10 minutes.

For me it means, when I run SQL*Plus or Toad from my maching, and I do not run anything during 10 minutes I recive this error. To reistablish I have to CLOSE the SQL*Plus or TOAD and reestablish my connection.

Any way in most cases, ORA-03113 implies that you process was killed on Unix side.

http://www.experts-exchange.com/Databases/Oracle/Q_20097507.html
0
 
LVL 4

Expert Comment

by:iozturk
ID: 8140482
Did you set connection timeout parameter? If not its default to OLEdb and ODBC to 90 seconds and your query seems to run more.
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 10154412
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ/No Refund.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 10214617
PAQed - no points refunded (of 125)

Computer101
E-E Admin
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question