how to map error code with error message

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
nirdosh_a
Posts: 4
Joined: Wed Nov 22, 2006 10:30 am
Location: India

how to map error code with error message

Post by nirdosh_a »

If we are provided with standard error code for oracle is there a means to derive the error message corresponding to that error code.
Do we have any table where this standard error codes and messages are stored?
Thanks
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

You can get error descrpton from doumetation as wel as by using DBMS_ERROR_TEXT e.g.

my_error_text:=SQLERRM ||? ?|| DBMS_ERROR_CODE ||?-?|| DBMS_ERROR_TEXT ;
nirdosh_a
Posts: 4
Joined: Wed Nov 22, 2006 10:30 am
Location: India

Post by nirdosh_a »

Right,
but sqlerrm ,sqlcode are functions to catch recent error occured in database level
DBMS_ERROR_CODE and DBMS_ERROR_TEXT are to handle database errors in forms. ...
Is there a way to derive the error message if the error code is provided .The error code is ORA error code not FRM error code.
Is there any table which has all these error codes and messages stored.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests