Re: 10g Bug with Numeric Precision/Scale?

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 07 Sep 2005 20:19:02 +0200
Message-ID: <431f2f02$0$24151$9b4e6d93@newsread4.arcor-online.net>

James Carr schrieb:
> I've found a 10.1.0.4.0 machine
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bi
> PL/SQL Release 10.1.0.4.0 - Production
> CORE 10.1.0.4.0 Production
> TNS for Solaris: Version 10.1.0.4.0 - Production
> NLSRTL Version 10.1.0.4.0 - Production
>
> I still get the same strange behaviour as on 10.1.0.3
>
> 1.23100007
> 1.23
> 1.23
> 1.231
> 1.23100007
> 1.23100007
> 1.23100007
> 1.231
>
> Daniel, when you tried it on 10.1.0.4.0 how did you get the correct
> answer?
>
> ~
> James
>

If you search in the bug database for keywords "not constrained %type parameter", you find a lot of notes, this one looks very similar to yours http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUG&p_id=4507743

Best regards

Maxim Received on Wed Sep 07 2005 - 13:19:02 CDT