Database Administration (MOSC)

MOSC Banner

ORA-01427: single-row subquery

edited Feb 23, 2015 11:19AM in Database Administration (MOSC) 4 commentsAnswered ✓

Hi,

on 11.2.0.4 on Win 2008.

When running  DBMS_HM.RUN_CHECK

I receive :

ORA-00604: error occurred at recursive SQL level 1

ORA-01427: single-row subquery returns more than one row

Here is what I run :

SQL> execut DBMS_HM.RUN_CHECK('Dictionary Integrity Check', 'my_run1');

BEGIN DBMS_HM.RUN_CHECK('Dictionary Integrity Check', 'my_run1'); END;

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-01427: single-row subquery returns more than one row

ORA-06512: at "SYS.DBMS_HM", line 191

ORA-06512: at line 1

Thanks and regards.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center