Microsoft KB Archive/191275

= BUG: All Numeric Parameter Values Are Treated as Integer =

Article ID: 191275

Article Last Modified on 3/7/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q191275



SYMPTOMS
When directly executing Oracle procedural objects such as procedures and functions that have numeric parameters, values entered for the parameters will be truncated for execution.



RESOLUTION
Execute the objects from an external tool, a script in a database project, or a driver procedure without parameters.



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.



Steps to Reproduce Behavior
  Execute the following function from data view or the editor: CREATE OR REPLACE FUNCTION HALF ( theparam IN number ) RETURN NUMBER IS halftheparam NUMBER(10,2); BEGIN halftheparam := theparam/2 ; RETURN(halftheparam); END;  Enter 11.9 for the parameter value.

The following appears in the output window: Running SCOTT."HALF" ( THEPARAM = 11.9 ).

No rows affected. RETURN_VALUE = 5.5 Finished running SCOTT."HALF".

The following is what is expected in the output window:

Running SCOTT."HALF" ( THEPARAM = 11.9 ).

No rows affected. RETURN_VALUE = 5.95 Finished running SCOTT."HALF".

Keywords: kbbug kbdatabase kb3rdparty kbpending KB191275

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.