Returncode value in sys.aud$ 1

[RogersJ]

I'm reporting out on the contents of the aud$ table. The returncode column will contain either a failure code or 0 for success.

How do I determine which message file to interogate for the error message text ?

Specifically the return code 20500, which was generated by an update statement.

When I search all the message files it would appear I have two choices:

/oracle/v9205: grep 20500 */mesg/*msg
network/mesg/vpxdbaus.msg:20500,00000,"dlm requests"
rdbms/mesg/rmanus.msg:20500, 1, "media recovery aborted"


The rest of my returncodes resolve using $ORACLE_HOME/rdbms/mesg/oraus.msg.

Thanks for your help.

 

[sem]

In Oracle you may get error message by calling sqlerrm(error_code) function, but numbers from -20000 to -20999 are reserved for user-defined errors, thus the meaning of that (-20500) error is known only for application developer (most probably is raised in trigger if you really make only update). So the conclusion: there's no such file, text message passed by application developer may be obtained by calling sqlerrm without parameter immediately after failure.

Regards, Dima

http://seminihin.narod.ru