Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Raise Application Error on Dynamic Action

JSonySCCJul 18 2013 — edited Jul 19 2013

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

0

......message: AJAX call returned server error ORA-20003: Customer has already been matched for Execute PL/SQL Code.4

0

......is_internal_error: true4

0

......apex_error_code: APEX.AJAX_SERVER_ERROR4

0

......ora_sqlcode: -200034

0

......ora_sqlerrm: ORA-20003: Customer has already been matched4

0

......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

0

......component.type: APEX_APPLICATION_PAGE_DA_ACTS4

0

......component.id: 231852037977562094

0

......component.name: NATIVE_EXECUTE_PLSQL_CODE4

0

...Execute Error Handling Callout defined on Page or Application Level4

0

...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

0

......Values changed by callout:4

0

.........message: An unexpected internal application error has occurred. Please get in contact with your system administrator and provide reference# for further investigation.4

0

.........display_location: ON_ERROR_PAGE4

100

Stop APEX Engine detected4

0

Final commit4-
1 - 59
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2013
Added on Jul 18 2013
4 comments
5,351 views