Good evening, I need your help Please, many times and in a Production System yields an Error:
ORA-01438: value larger than specified precision allowed fo
There is a Work Around to square and fix the problem
But in the next query i can not see these numbered fields cause the overflow:
select COD_CLIENTE,NUM_ABONADO,COD_CICLFACT,COD_CARG,max(dur_real) Duracion, max(dur_fact) DuraFactur
from tol_maintable
group by COD_CLIENTE,NUM_ABONADO,COD_CICLFACT,COD_CARG,dur_real,dur_fact
having dur_real > 700000000 or dur_fact > 700000000
order by DURACION,DuraFactur;
Output:
COD_CLIENTE NUM_ABONADO COD_CICLFACT COD_CARG DURACION DURAFACTUR
43729985 4068016 261222 9945 722251129 722252744
43767279 3810491 10123 9945 772093409 772093409
From this table, I woud like to know if there is another numbered field causing the overflow?
This is the definition table:
SQL> desc tol_maintable
Name Null? Type
COD_OPERADOR NOT NULL NUMBER(5)
COD_REGI NOT NULL VARCHAR2(2)
COD_GRUPO NUMBER(8)
COD_CLIENTE NOT NULL NUMBER(8)
NUM_ABONADO NOT NULL NUMBER(8)
COD_CICLFACT NOT NULL NUMBER(8)
NUM_PROCESO NUMBER(8)
IND_EXEDENTE VARCHAR2(1)
COD_PLAN VARCHAR2(5)
IND_BILLETE NOT NULL VARCHAR2(2)
COD_CARG NOT NULL NUMBER(5)
TIP_DCTO VARCHAR2(5)
COD_DCTO VARCHAR2(5)
COD_ITEM VARCHAR2(5)
IND_UNIDAD VARCHAR2(5)
CNT_INICIAL NUMBER(14,4)
CNT_AUX NUMBER(14,4)
MTO_REAL NUMBER(14,4)
MTO_FACT NUMBER(14,4)
MTO_DCTO NUMBER(14,4)
DUR_REAL NUMBER(9)
DUR_FACT NUMBER(9)
DUR_DCTO NUMBER(9)
TIP_MONE VARCHAR2(5)
CNT_LLAM_REAL NUMBER(8)
CNT_LLAM_DCTO NUMBER(8)
CNT_LLAM_FACT NUMBER(8)
HS_ESTR_ACOP NOT NULL NUMBER(14)
COD_AREAA NOT NULL VARCHAR2(5)
Is there any approach to fix the former query with the numbered field causing this problem?
I apprecite your help in advanced