Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Multi-column popup LOV errors out in detail form

Sharad K-OracleNov 4 2019 — edited Nov 4 2019

Version 19.2

Create a multiple column list of values or select list and attach to detail field in master-detail form. Not sure if this is supported in detail form.

Get following error:

1 error has occurred

  • Ajax call returned server error ORA-01722: invalid number for .

From Debug :

Exception in "Issue Detail":

Error Stack: ORA-01722: invalid number

ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 1222

ORA-06512: at "SYS.DBMS_SQL", line 1726

ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 1218

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 403

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 617

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 747

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 792

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 1333

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 2441

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 2134

Backtrace: ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 1222

ORA-06512: at "SYS.DBMS_SQL", line 1726

ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 1218

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 403

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 617

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 747

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 792

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC_LOCAL", line 1333

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 2441

ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 2134

ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 3448
This post has been answered by Sharad K-Oracle on Nov 4 2019
Jump to Answer

Comments

Post Details

Added on Nov 4 2019
#apex-discussions
1 comment
72 views