17 Eylül 2014 Çarşamba

ORA-06502 PL/SQL: numeric or value error

This problem occured when our periodic request stopped in our E-Bussiness Suite.

System stopped the request. There is not any answer for now.

Inside the request,there was control filling a table each day twice with varchar2 datatype approxametely having 7-10 size.

It means varchar2(7) and varchar(10) for each row.


But in our code varchar2 type which hold these datas has varchar2(100) size. So in there days,it filled up the table with 55 rows. It equals nearly 55x10=550 size.


So,

Our parameter was not enough sized to hold these datas.


This is a case. It might depend on the issue that you are carrying out.


Hiç yorum yok:

Yorum Gönder