代码之家 › 专栏 › 技术社区 › kentcdodds

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

function oracle sql

2

kentcdodds · 技术社区 · 13 年前

我的问题: 我在找一个函数 SQLERRM 这将为我提供所有Oracle错误代码的描述。

从…起 this website ,我发现了以下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

我是不是误解了什么,或者这是可能的?

1 回复 | 直到 9 年前

1

Anjan Biswas 13 年前

有点像

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 是否有类似的错误类型 ora , amd 等等,以及 error 是代码。但您需要确保您对所有安装的目录都有访问权限。

This 是您需要的PDF格式。