ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Publicado por vicente (1 intervención) el 08/11/2017 14:43:35
hola a todos, estoy empezando a programar en PL/SQL y ya empece con problemas u.u, no encuentro manera de pasar decimales al procedimiento, espero me puedan ayudar
error:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1
06502. 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.
1
2
3
4
5
6
7
8
9
10
11
12
13
drop table libros;
create table libros(precio number(4,2)
);create or replace procedure pa_libros_insertar
(aprecio IN number)
as
begin
insert into libros values (aprecio);
end;
EXECUTE pa_libros_insertar(1.4);
error:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1
06502. 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.
Valora esta pregunta
0
