My Oracle Support Banner

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 and later
Information in this document applies to any platform.


After upgrading Database from version 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 to 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.