Now we found one report finished with good , but there still have some data missed. it is really headache thing. as we run the query in PL SQL, there is no issue for this. as we can find the correct data. but we run the report in EBS, there data is incomplete. lucky at last we found the error from the log:
Raise the unknown error, the error is ORA-06502: PL/SQL: numeric or value error.
Then we compare the last data in the reprot with the next data we run in pl/sql. at last we found one record 一个值的长度超过了上面一个值。then we check the char we defined, it is not enough for the length :))
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15225049/viewspace-709612/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
