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 AUGUST 13, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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

Changes

 Database upgraded from version 11.2.0.4 to 12.2.0.1. However this applies to other 12c releases as well.

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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