當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、看到錯誤了 就可以進行相應的處理,例子中的錯誤是調用的程序包出現了問題