oracle pl/sql pass exception type to function

Question

i'm trying to find out if there is a way to get the type of exception without explicitly implementing all predefined Exceptions in a when clause.

I wrote a function to send a mail. I call this function in the when others clause of a PL/SQL Procedure, is there a way to pass the type as a varchar or something?
It would be excelling to get the Exception message to pass as an argument too.

regards

docs.oracle.com/cloud/latest/db112/LNPLS/errors.htm#LNPLS848 — Mat
– Mat, Commented Sep 13, 2017 at 6:42
thanks, tested it and worked fine. Please make an answer out of it — k4yaman
– k4yaman, Commented Sep 13, 2017 at 6:53

k4yaman · Accepted Answer · 2017-09-18 06:53:32Z

1

As Mat suggested in his comment, one can simply use the variables SQLCODE and SQLERRM to retrieve the Exception. It does not retrieve the type of Exception per se but it definitely provides enough information to solve the Problem. Oracle Documentation

answered Sep 18, 2017 at 6:53

k4yaman

4858 silver badges21 bronze badges

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

1 Comment

Stuporman Over a year ago

The link is dead.

J88 · Accepted Answer · 2017-09-13 14:56:40Z

0

Search in Oracle Documentation for : DBMS_UTILITY.FORMAT_ERROR_STACK

answered Sep 13, 2017 at 14:56

J88

8418 silver badges22 bronze badges

Comments

Moudiz · Accepted Answer · 2017-09-14 06:23:46Z

0

there are several way , I use SQLERRM

EXCEPTION
  WHEN CANNOTPROCEED THEN


      ORA_ERROR:=SQLERRM;

      ROLLBACK;
insert into LOG_TABLE (LOG_ERROR) Values();
commit;

answered Sep 14, 2017 at 6:23

Moudiz

7,42723 gold badges87 silver badges166 bronze badges

Collectives™ on Stack Overflow

oracle pl/sql pass exception type to function

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related