BUG: All Numeric Parameter Values Are Treated as Integer

MORE INFORMATION

Steps to Reproduce Behavior

1. 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;
   						

2. Enter 11.9 for the parameter value.

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

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

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

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