Where Oracle Errors are Stored ?

[sjadhavdba]

Where the Oracle Errors are stored ? any object from which i can get information of each and every oracle error. Or it is stored in some other format or external file. DBA_ERRORS only stores the current errors for any objects. but i want to get all the oracle error list.

Any idea.

[adewri]

In ORCALE_HOME serach for *.msg files and look into them.

[DaPi]

. . . or try someting like:

DECLARE
    errno_v NUMBER;
    msg_v   VARCHAR2(200);
BEGIN
FOR errno in 1000..1100 LOOP
    errno_v := errno * -1;
    msg_v := sqlerrm(errno_v) ;
    dbms_output.put_line(msg_v) ;
END LOOP;
END;
/

I'll leave you to experiment . . . .

[sjadhavdba]

But how this errors are read in Oracle. I mean is there any background process which reads and displays proper message at proper time. At the time of Database Creation we get the ORA error , at the time of DML, DDL, TCL commands we get the ORA error. How this activity is done. Is it a job of Server process ?

[TomazZ]

I believe that it is not for us to know, it is not open source project.
I guess there is a module that do it and gets invoked from all over the code when needed.

[abhaysk]

Originally posted by TomazZ
I guess there is a module that do it and gets invoked from all over the code when needed.

PL/SQL Engine for sequential/procedural execution

SQL Executor for SQL statement execution.

When exceptiion, i belive it will call appropirate Proc/function which will return the error number/error mesage