Float values in NUMBER(11) columns with 10g

From: <alex.luerken_at_web.de>
Date: 12 Apr 2005 05:56:56 -0700
Message-ID: <1113310616.316577.308880@o13g2000cwo.googlegroups.com>

Dear Readers,

we have a severe problem retrieving data from an Oracle 10g environment when using different kinds of select statements from a variety of our development tables.

The systems are setup with the following components Client: Oracle 10.1.0.3 with PLSQL Developer 6.0.2.880 Server: Oracle 10.1.0.3 Server on an AIX 5.2 machine

The behaviour seems random for stored data and new inserted data and seems only to occur if a select statement without a where clause or a select statement with a where clause not touching any table columns (like where 1=1) is used.

For example:
Table RFCTID
TID VARCHAR2(24) NOT NULL

DIRECTION NUMBER(11)   NOT NULL
IDOCNO    NUMBER(11)   NOT NULL
STATUS    NUMBER(11)   NOT NULL

PK: TID, DIRECTION, IDOCNO The table consists of 2 records:

TID          DIRECTION   IDOCNO      STATUS
A78839929    2           221072      0
A78839930    2           221076      0

With the subsequent select statement "Select * from RFCTID where DIRECTION = 2" both records are shown correctly.

Neglecting the where clause (e.g. Select * from RFCTID) the result differs horribly:

TID          DIRECTION               IDOCNO
A78839929    2                       221072
             -1,02020202020202E126   -1,02020202020202E126

STATUS
0
-1,02020202020202E126

The following error tracking was already tried without further results resulting in the exact same behaviour:
- dropping tables and recreation of tables using scripts as well as
creation "by-hand"
- creation of temporary tables with the pattern "create table x as
select * from table y"

Hopefully someone can help as the project is currently in the test phase on the customers network.

Thanks in advance. Received on Tue Apr 12 2005 - 07:56:56 CDT