UTL_HTTP And UTL_SMTP Calls Fail With ORA-01426: numeric overflow and ORA-24247 Errors After Database Upgrade to 12c
(Doc ID 2575911.1)
Last updated on APRIL 03, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
After upgrading Database from version 18.104.22.168 to 12C, Calls using UTL_HTTP or UTL_SMTP request function fail with the following errors. These errors happen even after rebuilding the ACLs in Upgraded Database, but to no avail.
Note:- This case ONLY applies when you receive ORA-01426: numeric overflow error along with ORA-24247. For ORA-24247 and ORA-29273 errors alone there can be different reasons and should be troubleshooted accordingly.
Database upgraded from version 22.214.171.124 to 126.96.36.199. However this applies to other 12c releases as well.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document