checking for specific error code in PL/SQL exception block

Question

I am getting the ORA-06503: PL/SQL: Function returned without value error in a pl/sql trigger code. I actualy want to do some specific exception handling only if this error occurs else do the regular exception handling in my code. My question is how do I capture the specific ORA codes in exception blocks. Like If I want to add a if condition like

If(oracode = something) then ...
else ...

the SQLERRM gives the ora code with error message. how do I use this in IF condition ?

Need help with this

Thanks.

jim mcnamara · Accepted Answer · 2013-05-08 23:21:57Z

3

You are looking for SQLCODE - these are negative numbers when there is an error.

if SQLCODE = -6503 then  ....

answered May 8, 2013 at 23:21

jim mcnamara

16.5k2 gold badges40 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

checking for specific error code in PL/SQL exception block

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related