求救:oracle触发器异常

wifox

一个存储过程跑的时候,报如下异常.
异常代码如下

SQL> BEGIN PKGADVDAYALERT.check_dinner('0004','20061225'); END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06512: at "CRM.TRI_SERVICE_ALERTPOOL_BINSERT", line 2
ORA-04088: error during execution of trigger
'CRM.TRI_SERVICE_ALERTPOOL_BINSERT'
ORA-06512: at "CRM.PKGADVDAYALERT", line 1497
ORA-06512: at line 1


TRI_SERVICE_ALERTPOOL_BINSERT是个触发器,调用序列的值.现序列最大值到了1000000565

请问是不是触发器的问题?

wifox

调试发现程序执行到这里的时候 出问题.PKGidvalueSQL.getNextID('seq_alertid');
这个函数相当于一个序列

CREATE OR REPLACE TRIGGER TRI_Service_AlertPool_BInsert
  BEFORE INSERT ON Service_AlertPool
  FOR EACH ROW
BEGIN
  :New.AlertID :=PKGidvalueSQL.getNextID('seq_alertid');
END;

PKGidvalueSQL.getNextID('seq_alertid')=1000000585

[ 本帖最后由 wifox 于 2006-12-26 18:40 编辑 ]

numenhuang

原帖由 wifox 于 2006-12-26 18:37 发表
调试发现程序执行到这里的时候 出问题.PKGidvalueSQL.getNextID('seq_alertid');
这个函数相当于一个序列

CREATE OR REPLACE TRIGGER TRI_Service_AlertPool_BInsert
  BEFORE INSERT ON Service_AlertPool
  FOR EACH ROW
BEGIN
  :New.AlertID :=PKGidvalueSQL.getNextID('seq_alertid');
END;

PKGidvalueSQL.getNextID('seq_alertid')=1000000585

AlertID这个字段具体定义?如果是number,精度多少?