PL/SQL (MOSC)

MOSC Banner

how to ignore specific errorcode and let program proceed in PLSQL

edited Feb 19, 2014 3:53AM in PL/SQL (MOSC) 6 commentsAnswered

Hi ,

In prodedure,there are 3 half commits.

1--half commit  success

2--half commit  failed,    exception handle, but  if  the error code is ORA-01722, ignore and continue to do 3-half commit; else if error code is not ORA-01722,stop program at this stage,don't do 3-half commit.

3--half commit  success

I know we can use sub- exception(only handle for step2) to let the program proceed when SQLerror hanppend in step2, but not sure how  to stop program when the errorcode is not ORA-01722 ?

begin

..........

begin

.........

exception          ------exception handle for step2

when others then

end;

...............

end;

exception           -----main exception handle

when others  then

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