My Oracle Support Banner

Job Fails With ORA-21780 ORA-6512 After Upgrade from 11.2.0.1.0 To 11.2.0.3.0 (Doc ID 1537703.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Database was upgraded from 11.2.0.1 to 11.2.0.3.1.
Query using:

 XMLTYPE
  (
  REGEXP_REPLACE
  (
  SYS_XMLGEN
  (
  XMLELEMENT

See test case for details.
gets for each row error:

ORA-21780: Maximum number of object durations exceeded.
ORA-06512: at "SYS.UTL_SMTP", line 186
ORA-06512: at "I2B2STAGINGHPCE.SP_SEND_EMAIL", line 22
ORA-06512: at "I2B2STAGINGHPCE.USP_LOAD_FACT_POPCASES", line 650
ORA-21780: Maximum number of object durations exceeded.
ORA-06512: at "SYS.XMLTYPE", line 310
ORA-06512: at "I2B2STAGINGHPCE.FN_PERIOP_ONTIME", line 1112
...

Notes:
This was working fine in 11.2.0.1 and it is throwing this error in 11.2.0.3.1
Customer's database characterset is WE8MSWIN1252

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
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.