我的问题: 我正在寻找像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
我是不是误会了某件事?
就像是
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是代码。但是,您需要确保您具有对所有已安装目录的访问权限。
facility
ora
amd
error
这就是您需要的PDF格式。