Database Administration (MOSC)

MOSC Banner

dbms_scheduler error

edited Nov 16, 2009 6:35AM in Database Administration (MOSC) 3 commentsAnswered ✓
 Hello,

when submitting repeating jobs via the dbms_scheduler, it keeps throwing this error in the  alert log:

ora-01427 single-row subquery returns more than one row.

The job runs a procedure.  The procedure runs fine, doing all the correct things, I just get the above error everytime the procedure is run via dbms_scheduler.  There is nothing wrong with the p/l sql procedure itself.  

Is this a known bug?

Rae

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