admin

SQLERRM-类似的函数,用于其他错误类型

sql

我的问题:
我正在寻找像SQLERRM这样的函数,它将为我提供所有Oracle错误代码的描述。

此网站上,我找到了以下oracle错误类型列表:

AMD, AUD, CLS, DBV, DGM, DRG, EXP, IMG, IMP, KUP, LCD, LFI, LPX, LRM,
LSX, NCR, NID, NMP, NNC, NNF, NNL, NNO, NPL, NZE, O2F, O2I, O2U, OCI,
ORA-CODE, PCB, PCC, PLS, PLW, PRO, QSM, RMA, SQL, TNS, UDE, UDI, VID

我是不是误会了某件事?


阅读 102

收藏
2021-07-01

共1个答案

admin

就像是

SQL> !oerr ora 04043
04043, 00000, “object %s does not exist”
// *Cause: An object name was specified that was not recognized by the system.
// There are several possible causes:
// – An invalid name for a table, view, sequence, procedure, function,
// package, or package body was entered. Since the system could not
// recognize the invalid name, it responded with the message that the
// named object does not exist.
// – An attempt was made to rename an index or a cluster, or some
// other object that cannot be renamed.
// *Action: Check the spelling of the named object and rerun the code. (Valid
// names of tables, views, functions, etc. can be listed by querying
// the data dictionary.)

这是Oracle中的错误查找实用程序。

Usage: oerr facility error

facility是任何错误类型,例如oraamd等等,并且error是代码。但是,您需要确保您具有对所有已安装目录的访问权限。

就是您需要的PDF格式。

2021-07-01