G
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.
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.