当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.
// *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、看到错误了 就可以进行相应的处理,例子中的错误是调用的程序包出现了问题