Database Administration (MOSC)

MOSC Banner

Running the loop continuously

edited Oct 2, 2014 5:00AM in Database Administration (MOSC) 3 commentsAnswered

We are on 11.2.0.3. We have a dynamic PL/SQL blocking coming from some other location and while we run that block we get ORA-00001 intermittently. Sometimes the whole block error out with ORA-00001. To fix it we comment the line that returns the error and re-run it. The problem is we have too many PL/SQL blocks to run and its so difficult to edit / comment/ re-run the PL/SQL block again and again.

I've defined the EXCEPTION handler (DUP_VAL_ON_INDEX)  as well but the moment ORA-00001 is encountered the execution stops and it goes into EXCEPTION handler but doesn't error out of PL/SQL block.

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