| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> More on negative zero
We hear this will be fixed in 9.2.0.5
"SQL> alter oracle bug-free;"
<Bug:979657>ORACLE ALLOWS INSERT OF -0 (NEGATIVE ZERO) WHEN USING OCI VARNUM
TYPE
INTERFACERDBMS Ver: 8.0.5 By: ARU
Status: 80,Q/A To Development
Sup Pri: 2,Severe Loss of Service Fixed In Ver: 9.2.0.99
Fixed-Releases: 9205
Tags: CORR/LOG
Details:
Oracle allows an invalid Oracle numbers to be inserted into tables
when inserted using a bind variable in a ProC/OCI program or
by using some third party tool to populate tables.
Such invalid numbers can lead to wrong results or dumps in Oracle.
Note: This fix is enabled by setting <event 10843> at level 1
in 9.2. When enabled all IN numbers are checked for validity
and -0 is coerced to 0.
An invalid number will cause an ORA-1722 to be reported.
The fix is not enabled by default as it can lead to a performance
overhead in checking the number is valid
 |
 |