ORA-01460 unimplemented or unreasonable conversion requested Cause: The requested format conversion is not supported.
Action: Remove the requested conversion from the SQL statement. Check the syntax for the TO_CHAR, TO_DATE, and TO_NUMBER functions to see which conversions are supported. 是不是数据有问题
Action: Remove the requested conversion from the SQL statement. Check the syntax for the TO_CHAR, TO_DATE, and TO_NUMBER functions to see which conversions are supported. 是不是数据有问题
Cause: The requested format conversion is not supported. Action: Remove the requested conversion from the SQL statement. Check the syntax for the TO_CHAR, TO_DATE, and TO_NUMBER functions to see which conversions are supported.
进行insert 或者 update 每一条就commit一次
Procedure
BEGIN
DECLARE
TYPE ARY_NUMBER IS VARRAY(18) OF NUMBER; Pry_SHIKIRI_SHIIRE_GAKU ARY_NUMBER;
Pry_SHIKIRI_HENPIN_GAKU ARY_NUMBER;
Pry_HADAKA_SHIIRE_GAKU ARY_NUMBER;
Pry_REBATE_GAKU ARY_NUMBER;
Pry_BAIKA_SHIIRE_GAKU ARY_NUMBER;
Pry_ARARI_GAKU ARY_NUMBER; CURSOR Sor_SHITEN IS
SELECT SHITEN_COD FROM M_SHITEN ORDER BY SHITEN_COD;
BEGIN
没有走到这不符就出错了
EXCEPTION END;END;
然后commit301条正常更新了,
然后302就出错了
也是一条数据调用一次PL/SQL
执行5000条数据的操作
就没有这些问题不过这些Procedure没有用数组和游标
游标是这样,你调一次过程就打开一次游标读所有数据,可能会有问题,建议你打开一次就可以了,返回一个记录集,然后处理
说出来大家一定会笑的
赫赫原以为是PL/SQL的问题最后才发现是传参数的时候有一个String是累加,
应该在每次读数据初始化一下,
结果没有初始化,
最后累加超过范围了
就出现了上面的错误谢谢大家这么帮忙