Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00600 with large dataset and .net OracleClient

ORA-00600 with large dataset and .net OracleClient

From: Ian Cox <ian_cox2000_at_hotmail.com>
Date: 21 Jul 2003 10:55:40 -0700
Message-ID: <d6d6d9b8.0307210955.2da4f9e8@posting.google.com>


Hello.
I have a problem where I am calling a remote database and receiving back a relatively large amount of data. I am using the .net OracleClient and calling a stored procedure which is sitting on a database in California (I am in UK). After a pretty long wait 10-15 mins (I think) it returns with the error "ORA-00600 Internal error". The process works on a much smaller dataset so I know the code works in that sense.
My DB colleague thinks it is probably a timeout problem and asked me to increase the timeout at my end to a much larger value. However, there doesn't seem to be anyway to specify a timeout when using the .net OracleClient and also if I am getting an Oracle specific error that would imply to me that the error was at the Oracle end and not the .NET end.
Does anyone have any ideas?

Thanks in advance
Ian Received on Mon Jul 21 2003 - 12:55:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US