ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2588206.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

SQL> select distinct (a.username) "USER", count (r.xmldata) "TOTAL"
from dba_users a, xdb.xdb$resource r
where sys_op_rawtonum (extractvalue (value(r),'/Resource/OwnerID/text()')) = a.USER_ID
group by a.username;


fails with :

ERROR at line 2:
ORA-01422: exact fetch returns more than requested number of rows


ORA-04045: errors during recompilation/revalidation of SYS.XDS_ACL

ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 122

ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 122

Changes

Cause

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