Re: ORA-00600 with large dataset and .net OracleClient

Ian Cox wrote:

> 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

ORA-00600 is an unhandled error in Oracle. Open an iTAR at http://metalink.oracle.com.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)