Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: here's a good one from dizwell on the recent product launch
"Mark Townsend" <markbtownsend_at_sbcglobal.net> a écrit dans le message de news: 46A0C746.3000007_at_sbcglobal.net...
| Noons wrote:
| > On Jul 19, 12:35 pm, Mark Townsend <markbtowns..._at_sbcglobal.net>
| > wrote:
| >>> Nuno gave me bug 5092688.8
| ...
| >>
| >> I don't think this is what Nuno is talking about
| >
| > Let me see, Mark: I provide the bug
| > number to Jonathan and "this is not what
| > I'm talking about"? Are you even
| > READING?
| >
|
|
|
|
|
|
|
|
|
As you talk about a bone, here's one I found 2 days ago (SR6427362.992). It is closed as a duplicate of bug 2499608 opened on 06-AUG-2002 and never fixed.
The description is the following one:
<quote>
When NLS_NUMERIC_CHARACTERS is not set to the default '.,'
we get the following errors:
SQL> alter session set nls_numeric_characters='!:';
Session altered.
SQL> select to_number('1,234','9,999') from dual;
select to_number('1,234','9,999') from dual
*
ERROR at line 1:
ORA-01722: invalid number
SQL> select to_number('1,234','9,999.9') from dual; TO_NUMBER('1,234','9,999.9')
1 row selected.
First question: Why the error is reached in the first case? Second question: Then why it is not in the second one? </quote>
OK, it's not a terrific bug, easy to workaround, but why 5 years without being fixed?
Regards
Michel
Received on Fri Jul 20 2007 - 10:26:04 CDT