BUG: All Numeric Parameter Values Treated as Integer

ID: Q191275

The information in this article applies to:

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.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Execute the following function from DataView 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;


  2. 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".

Additional query words: 


Keywords          : kb3rdparty kbVisID600bug kbGrpASP 
Version           : WINDOWS:6.0
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: March 8, 1999