Invalid floating point operation

[herrsmag]

Hi,

Since I upgraded from 7.0 I get the message 'Invalid floating point operation' quite often when the select returns many rows.

Any ideas ??

//M

 

[herrsmag]

I'm running 7.1.2.1362 by the way.

//M

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[japjap]

I also have this problem. Here is the text of my debug.txt file (top 100 and bottom 100 lines only).

PL/SQL Developer
Version 7.1.3.1380
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 1,039,740 kB (379,692 available)
Paging file : 2,500,128 kB (1,920,244 available)
Virtual memory : 2,097,024 kB (2,031,904 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
debugsql

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files

Plug-Ins

Aliases
DEMO5
GEPRD
HFPRD2
JANUS5
SVPRD1
...

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)

DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll

TNS File
C:\oracle\product\10.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2

10/18/2007 12:16:49 PM Application started
10/18/2007 12:16:49 PM InitPreferences
10/18/2007 12:16:49 PM Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
10/18/2007 12:16:49 PM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
10/18/2007 12:16:49 PM PreferenceSet.Load OK
10/18/2007 12:16:49 PM Determine LocalPrefPath
10/18/2007 12:16:49 PM [1]: C:\Program Files\PLSQL Developer\Preferences
10/18/2007 12:16:49 PM LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\dmattis
10/18/2007 12:16:49 PM Load C:\Program Files\PLSQL Developer\Preferences\dmattis = 0
10/18/2007 12:16:49 PM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\dmattis\default.ini
10/18/2007 12:16:49 PM PreferenceSet.Load OK
10/18/2007 12:16:49 PM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\dmattis\user.prefs
10/18/2007 12:16:49 PM PreferenceSet.Load OK
10/18/2007 12:16:49 PM InitPreferences end
10/18/2007 12:16:49 PM SortPreferenceSets
10/18/2007 12:16:49 PM - Default dmattis
10/18/2007 12:16:49 PM - System Default
10/18/2007 12:16:50 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
10/18/2007 12:16:50 PM ReadString OK
10/18/2007 12:16:50 PM pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
10/18/2007 12:16:50 PM LoadPreferences
10/18/2007 12:16:50 PM LoadPreferences searching for default
10/18/2007 12:16:50 PM C:\Program Files\PLSQL Developer\Preferences\dmattis\default.ini
10/18/2007 12:16:50 PM LoadPreferences NewPref := nil
10/18/2007 12:16:50 PM LoadPreferences
10/18/2007 12:16:50 PM LoadPreferences Reading preferences
10/18/2007 12:16:50 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
10/18/2007 12:16:50 PM ReadString OK
10/18/2007 12:16:50 PM pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
10/18/2007 12:16:50 PM LoadPreferences ReadPosition
10/18/2007 12:16:50 PM LoadPreferences ToolsBrowserItemClick(nil)
10/18/2007 12:16:50 PM LoadPreferences CreateBrowserFilters...
10/18/2007 12:16:50 PM LoadPreferences Files
10/18/2007 12:16:50 PM LoadPreferences Logon
10/18/2007 12:16:50 PM LoadPreferences Buttons
10/18/2007 12:16:50 PM LoadPreferences Printer
10/18/2007 12:16:50 PM LoadPreferences BrowserFolders
10/18/2007 12:16:50 PM LoadPreferences
10/18/2007 12:16:50 PM LoadPreferences end
10/18/2007 12:16:50 PM MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\dmattis.lib
10/18/2007 12:16:50 PM FormCreate Logon.Execute
10/18/2007 12:16:55 PM TOracleSession PLSQLDevForm.Session Start Session.LogOn as dmattis@SVPRD2
10/18/2007 12:16:55 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
10/18/2007 12:16:55 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.015
10/18/2007 12:16:55 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20000)), nchr(20) from dual
10/18/2007 12:16:55 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
10/18/2007 12:16:55 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
10/18/2007 12:16:55 PM TOracleQuery Query End (1 record processed)
Duration = 0.016
10/18/2007 12:16:55 PM TOracleSession PLSQLDevForm.Session End
Duration = 0.375
10/18/2007 12:16:55 PM LogonHistorySave start

10/18/2007 12:21:24 PM TSQLThread SQLThread Suspend
10/18/2007 12:21:24 PM TSQLForm.ThreadFinished: SQLThread.Suspended
10/18/2007 12:21:24 PM SQLForm 21 rows selected in 8.968 seconds (more...)
10/18/2007 12:21:24 PM NavigationBookmarks.EnableButtons(Rebuild)
10/18/2007 12:21:24 PM NavigationBookmarks: Backward=0, Forward=0
10/18/2007 12:21:24 PM TOracleQuery $02AF30E0 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
10/18/2007 12:21:24 PM TOracleQuery $02AF30E0 End
Duration = 0.015
10/18/2007 12:21:24 PM SQLForm 21 rows selected in 8.968 seconds (more...)
10/18/2007 12:21:28 PM NavigationBookmarks.EnableButtons(Rebuild)
10/18/2007 12:21:28 PM NavigationBookmarks: Backward=0, Forward=0
10/18/2007 12:21:28 PM SQLForm Executing...
10/18/2007 12:21:28 PM TSQLThread SQLThread Suspend ended
10/18/2007 12:21:28 PM SQLForm Executing... (30)
10/18/2007 12:21:28 PM SQLForm Executing... (40)
10/18/2007 12:21:28 PM SQLForm Executing... (50)
10/18/2007 12:21:28 PM SQLForm Executing... (60)
10/18/2007 12:21:28 PM SQLForm Executing... (70)
10/18/2007 12:21:28 PM SQLForm Executing... (80)
10/18/2007 12:21:28 PM SQLForm Executing... (90)
10/18/2007 12:21:28 PM SQLForm Executing... (100)
10/18/2007 12:21:28 PM TOracleQuery $02AF33A0 Start Query.Next for up to 100 records
10/18/2007 12:21:28 PM TOracleQuery $02AF33A0 End (100 records processed)
Duration = 0.032
10/18/2007 12:21:28 PM SQLForm Executing... (110)
10/18/2007 12:21:28 PM SQLForm Executing... (120)
10/18/2007 12:21:28 PM SQLForm Executing... (130)
10/18/2007 12:21:28 PM SQLForm Executing... (140)
10/18/2007 12:21:28 PM SQLForm Executing... (150)
10/18/2007 12:21:28 PM SQLForm Executing... (160)
10/18/2007 12:21:28 PM SQLForm Executing... (170)
10/18/2007 12:21:28 PM SQLForm Executing... (180)
10/18/2007 12:21:28 PM SQLForm Executing... (190)
10/18/2007 12:21:28 PM SQLForm Executing... (200)
10/18/2007 12:21:28 PM TOracleQuery $02AF33A0 Start Query.Next for up to 100 records
10/18/2007 12:21:28 PM TOracleQuery $02AF33A0 End
Result = Invalid floating point operation
Duration = 0.062
10/18/2007 12:21:28 PM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
10/18/2007 12:21:28 PM TOracleQuery Query End
Result = ORA-24909: call in progress. Current operation cancelled
Duration = 0.015
10/18/2007 12:21:28 PM TSQLThread SQLThread Postmessage
10/18/2007 12:21:28 PM TSQLForm.ThreadFinished
10/18/2007 12:21:28 PM TSQLThread SQLThread Suspend
10/18/2007 12:21:29 PM TSQLForm.ThreadFinished: SQLThread.Suspended
10/18/2007 12:21:49 PM TOracleQuery $02AF30E0 Start Query.Execute
SQL = select 'x' from dual
10/18/2007 12:21:49 PM TOracleQuery $02AF30E0 End (1 record processed)
Duration = 0
10/18/2007 12:22:04 PM TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null

 

[Marco Kalter]

Can you send the complete file by e-mail?