More on negative zero
- From: Stephen.Lee@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Mar 2004 10:40:36 -0600
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
