Skip to Main Content

SQL & PL/SQL

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!

PL / SQL error

1089818May 11 2016 — edited May 11 2016

This appeared in apex today, no changes were made recently. Can anyone help?

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

Technical Info (only visible for developers)
  • is_internal_error: true
  • apex_error_code: WWV_FLOW_FORMS.ITEM_DEFAULT_ERR
  • original message: Error computing item default value for page item P67_CONTRACT_START_DATE.
  • original_additional_info: ORA-06502: PL/SQL: numeric or value error
  • ora_sqlcode: -6502
  • ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error
  • component.type: APEX_APPLICATION_PAGE_ITEMS
  • component.id: 4906069557844849903
  • component.name: P67_CONTRACT_START_DATE
  • error_backtrace: ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2107 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1033 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1047 ORA-06512: at "APEX_050000.WWV_FLOW_DYNAMIC_EXEC", line 662 ORA-06512: at "APEX_050000.WWV_FLOW_FORMS", line 1641
  • error_statement: begin wwv_flow.g_computation_result_vc := to_number(sysdate, 'DD-MON-YYYY'); end;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2016
Added on May 11 2016
6 comments
474 views