CODEWITHSUNDEEP
sqldatabaseoracle-database
Ajeet Singh
Ajeet Singh

Reputation: 437

How to create and Oracle trigger to return some DB Error code, not the Custom Exception but real DB ERROR?

I would like to know is it possible to return a DB ERROR code from trigger, rather than Custom exception created with RAISE_APPLICATION_ERROR. I have some requirement where i need to return an DB ERROR code like 1 for Unique Constraint. I have a purpose to ask this, because for some reason with some hash based partition we are not creating unique constraints on table and rather have one trigher with which i want to return Unique constraint as an error code after checking if the record exists in DB.

Upvotes: 0

Views: 127

Answers (1)

Janis Baiza
Janis Baiza

Reputation: 961

You can use:

RAISE DUP_VAL_ON_INDEX;

Only in this case you can't pass any arguments to this error and you will get:

ORA-00001: unique constraint (.) violated

Upvotes: 1

Related Questions