ORA-03113 exception thrown

[Guest]

Background - VB.NET v1.1 SP-1. Query Oracle database using Microsoft .NET
provider for Oracle (System.Data.OracleClient). Exception is thrown using
both get data methods: 1.) OracleCommand.ExecuteReader() 2.)
OracleDataAdapter.Fill()

Problem - A certain query which happens to contain a Group By and Sum throws
an ORA-03113 exception. We traced through alert.log and other logs within
Oracle and determined an internal exception of ORA-07445 was thrown when
query was executed in the database.

I can take the same query and execute it from other query tools fine:
sqlplus, plsqldeveloper and etc.

I noticed a hotfix that addressed something similar to this, but reading
through the documentation this hotfix was included in .NETv1.1 SP-1. I've
confirmed that I have SP-1 by looking in registry at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework
Setup\NDP\v1.1.4322\1033\SP value is 1.

My TestOracleQuery project runs fine for all other Select statements except
ones similar to one described earlier.

Any help with this ORA-03113 is greatly appreciated.

 

[Guest]

Additional background: Connecting to Oracle 9.2.0.7.0 Enterprise Edition.

I took my TestOracleQuery project opened and rebuilt in Visual Studio 2005
and ran test query. It produced the same "ORA-03113".

Any help is appreciated.

Gene McCrory