How to get Oracle error message from error number?

Question

I'm writing a C# application that executes some functions stored in packages in oracle database. Unfortunately, I don't have access and I can not change the structure of these functions...

The functions are made such that, when the operation went good, they return 0, otherwise they return the oracle error code number.

Of course if I search for these codes (ORA-xxxxx) in the internet I can know what went wrong but I would like to display, in case of an error, a message to the user to understand the error instead of just showing the error number.

Does anyone know to get the oracle error message associated with the error number ?

Thank you in advance.

Multisync · Accepted Answer · 2014-12-04 12:19:57Z

3

CREATE OR REPLACE FUNCTION get_error_msg(f_code IN NUMBER) RETURN VARCHAR2
AS
BEGIN
   RETURN sqlerrm(-f_code); 
END;

select get_error_msg(100) from dual;

answered Dec 4, 2014 at 12:19

Multisync

8,8271 gold badge20 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

How to get Oracle error message from error number?

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