can't use fraction as parameter for procedure in oracle
I can reproduce the error:
CREATE TABLE t (n NUMBER);INSERT INTO t VALUES (10);CREATE OR REPLACE PROCEDURE p (p_n NUMBER) ASBEGIN UPDATE t SET n=p_n;END p;/-- ok:exec p(8/10);PL/SQL procedure successfully completed.-- ok:DECLARE y NUMBER := 0.8;BEGIN p(y);END;/PL/SQL procedure successfully completed.--error:exec p(0.8);ORA-06502: PL/SQL: numeric or value error: character to number conversion errorORA-06512: at line 106502. 00000 - "PL/SQL: numeric or value error%s"*Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).*Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
(Oracle 11.2.0.4.0 EE 64bit)