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!

ORA-01722: invalid number

Alexandra RobinJan 15 2014 — edited Jan 16 2014

All I am doing (I think) is moving items around on a form by clicking on the Edit Links yellow arrow and changing the sequence number.  I am making sure I am not duplicating numbers. We did an upgrade to recently and this among other errors and I don't know why.  I'm doing the same methodical thing.  Frustrated! Help!!  Thanks in advance!

Technical

Info (only visible for developers)is_internal_error: false

  • ora_sqlcode: -1722
  • ora_sqlerrm: ORA-01722: invalid number
  • component.type: APEX_APPLICATION_PAGE_PROCESS
  • component.id: 4157714168643973
  • component.name: Fetch Row from MAT_SUBSTITUTIONS
  • error_backtrace: ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1064 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1090 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 832 ORA-06512: at "APEX_040200.WWV_FLOW_DML", line 551 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 333

MORE CLUES from the debug??

Logging exception in final_exception_handler: Sqlerrm: ORA-20987: APEX - ORA-01722: invalid number Backtrace: ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 861 ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 896 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 917 ORA-06512: at "APEX_040200.WWV_FLOW_PAGE", line 1917 ORA-06512: at "APEX_040200.WWV_FLOW", line 6441

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2014
Added on Jan 15 2014
2 comments
888 views