日期:2014-05-16  浏览次数:20391 次

查看ORA错误

当form出现ora错误时,可以使用如下方法进行查询错误
例如打开form遇到了FRM-40735:WHEN-BUTTON_PRESSED出现了异常:ORA-04063
1、进入数据库,输入oerr ORA 04063
[oratst2@oracletest ~]$ oerr ORA 04063
04063, 00000, "%s has errors"
// *Cause:  Attempt to execute a stored procedure or use a view that has
//          errors.  For stored procedures, the problem could be syntax errors
//          or references to other, non-existent procedures.  For views,
//          the problem could be a reference in the view's defining query to
//          a non-existent table.
//          Can also be a table which has references to non-existent or
//          inaccessible types.
// *Action: Fix the errors and/or create referenced objects as necessary.
2、看到错误了 就可以进行相应的处理,例子中的错误是调用的程序包出现了问题