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 AUGUST 13, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
After upgrading Database from version 184.108.40.206 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 220.127.116.11 to 18.104.22.168. 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