ORA- 00932

Moin,

leider bekomme ich beim öffnen der Readseite immer wieder folgende Meldung(Oracle Adapter):

ORA- 00932

Was ist da los? Ich verstehe das nicht!

Bitte um schnelle Hilfe!

VG
Sven

Hier das Fehlerprotokoll vom Flowheater:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OracleClient.OracleException: ORA-00932: inconsistent datatypes

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleDataReader.ReadInternal()
at System.Data.OracleClient.OracleDataReader.Read()
at FlowHeater.Core.Adapter.DatabaseAdapter.HlQ8y5iiqpLb6Xggx4w(Object )
at FlowHeater.Core.Adapter.DatabaseAdapter.Read(Int32 rows, Boolean bInit)
at FlowHeater.Core.Adapter.DatabaseAdapter.ys1VjZia25U7r2tKFgK(Object , Int32 MaxRows, Boolean bInit)
at FlowHeater.Core.Adapter.DatabaseAdapter.DoWork(Int32 nRows)
at FlowHeater.Core.Fitter.aOE4IlPFkHXp9txLL1O(Object , Int32 nRows)
at FlowHeater.Core.Fitter.DoWork(Int32 MaxRows)
at FlowHeater.Core.Adapter.TextFileAdapter.ZNQIeMV3iJJCUCjifiJJ(Object , Int32 MaxRows)
at FlowHeater.Core.Adapter.TextFileAdapter.GetFirstLinesAndSplit(Int32 lines)
at FlowHeater.Core.Controls.FHTextFileAdapterCutter.8B44tIVQoC5nUU5CTF7W(Object , Int32 lines)
at FlowHeater.Core.Controls.FHTextFileAdapterCutter.UpdateFromAdapter()
at FlowHeater.Core.Controls.FHTextFileAdapterCutter.qXHc9iBoP(Object , EventArgs )
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Label.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5466 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

---

FlowHeater
Assembly Version: 2.5.0.0
Win32 Version: 2.5.0.0
CodeBase: file:////tools/Flowheater/BIN/FlowHeater.exe

---

System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5466 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

---

FlowHeater.Core
Assembly Version: 2.5.0.0
Win32 Version: 2.5.0.0
CodeBase: file:////tools/Flowheater/BIN/FlowHeater.Core.DLL

---

System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5460 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

---

System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5462 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

---

System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

---

System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

---

System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

---

System.Data.OracleClient
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data.OracleClient/2.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll

---

System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll

---

System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

---

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Hallo Sven,

Die Oracle Fehlermeldung "ORA-00932: inconsistent datatype" deutet darauf hin das du in der Abfrage der Daten versuchst einen Datentyp in einen anderen nicht zulässigen Datentyp umwandeln möchtest.

Folgende Infos benötige ich noch zur weiteren Analyse:

1. Welche Oracle Datenbank Server Version setzt du ein
2. Welche Oracle Client Version hast du installiert
3. Verwendeter SQL Select
4. Funktioniert der Zugriff auf Oracle Datenbanken mit Hilfe des Oracle Adapter generell nicht bei Dir?

Moin Robert,

können wir mal telefonieren?

VG
Sven