Hi
I am using Apex 4.2. On a click of button a Dynamic Action is written, which calls a DB Package. The DB package has exception handlers and also the package has two output parameters
Error Code and Error Msg
So in my code(Dynamic Code) i make a call to the package and checks the value for Erroc Code.
Begin
Package call......
If v_error_code <> '0' Then
Raise SC_Error;
End if;
Exception
When SC_Error Then
RAise_Application_error(v_err_code, v_err_msg);
End;
But when i run the page and I click I get an Internal exception error
Output from Debug -- I am not sure what the Cell in Red colour means, because the package is returning a correct message (before the red line).Can anyone help please??
Thanks
JS

| | | ......message: AJAX call returned server error ORA-20003: Customer has already been matched for Execute PL/SQL Code. | 4 | 
| ......is_internal_error: true | 4 | 
| ......apex_error_code: APEX.AJAX_SERVER_ERROR | 4 | 
| ......ora_sqlcode: -20003 | 4 | 
| ......ora_sqlerrm: ORA-20003: Customer has already been matched | 4 | 
| ......error_backtrace: ORA-06512: at line 41 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 973 ORA-06512: at "SYS.WWV_DBMS_SQL", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN_UTIL", line 2304 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_ACTION_NATIVE", line 442 | 4 | 
| ......component.type: APEX_APPLICATION_PAGE_DA_ACTS | 4 | 
| ......component.id: 23185203797756209 | 4 | 
| ......component.name: NATIVE_EXECUTE_PLSQL_CODE | 4 | 
| ...Execute Error Handling Callout defined on Page or Application Level | 4 | 
| ...Execute Statement: begin declare l_error wwv_flow_error_api.t_error; begin l_error := wwv_flow_error_api.g_error; wwv_flow_error_api.g_error_result := apx_error_utils.handleerror ( p_error => l_error ); end; end; | 4 | 
| ......Values changed by callout: | 4 | 
| .........message: An unexpected internal application error has occurred. Please get in contact with your system administrator and provide reference# for further investigation. | 4 | 
| .........display_location: ON_ERROR_PAGE | 4 | 
| Stop APEX Engine detected | 4 | 
| Final commit | 4 | - | 1 - 59 |