Exception Handling
Any exceptions that occur within a stored procedure will produce an ORA-XXXX error and it will be relayed to the reports wand user with reference to the Reports Wand Database Package. It is imperative to test any stored procedures that are assigned to Reports Wand definitions before providing access to the users. Below is an example of what the error would look like.
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.XXE4A_REPORTS_WAND_PKG", line 16
ORA-06512: at line 1
(com.wands.servlet.wand.oracle.v6_0_0.reportswand.requests.ExecuteReportDrilldownServer) ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.XXE4A_REPORTS_WAND_PKG", line 16
ORA-06512: at line 1