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.

Error when loading dynamic form

User_OQ7VGApr 16 2020

Workspace: FX_WS_3932
App: 251
Page: 2091

Hello,

when loading a value for a Grid item type the below error happens:

For this example the item value is hard coded in the query for the specific item type!

See example in PAGE 2091 , Workspace : FX_WS_3932.

Technical Info (only visible for developers)

  • is_internal_error: true

  • apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR

  • ora_sqlcode: -936

  • ora_sqlerrm: ORA-00936: missing expression ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1500 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2501 ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 895 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN_UTIL", line 1768 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN_UTIL", line 2243 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 873 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 590 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 576 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2033 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2007 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 852 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 930 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN_UTIL", line 2162 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN_UTIL", line 1737 ORA-06512: at "FOEX_040200.FX_P_GRID_COMBO", line 700 ORA-06512: at "FOEX_040200.FX_P_GRID_COMBO", line 1229 ORA-06512: at "FOEX_040200.FX_P_FORM", line 3323 ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 442 ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 813 ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 923 ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 1097 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 599 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2486 ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1476

  • component.type: APEX_APPLICATION_PAGE_REGIONS

  • component.id: 632341587668004251

  • component.name: Dynamic Form

  • error_backtrace:

    ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658
    ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 576
    ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1500
    ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2501
    ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 895
    ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN_UTIL", line 1768
    ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN_UTIL", line 2243
    ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 873
    ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 590
    ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658
    ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 576
    ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2033
    ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2007
    ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 852
    ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 930
    ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN_UTIL", line 2162
    ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN_UTIL", line 1737
    ORA-06512: at "FOEX_040200.FX_P_GRID_COMBO", line 700
    ORA-06512: at "FOEX_040200.FX_P_GRID_COMBO", line 1229
    ORA-06512: at "FOEX_040200.FX_P_FORM", line 3323
    ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 442
    ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 813
    ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 923
    ORA-06512: at "FOEX_040200.FX_P_DYN_FORM", line 1097
    ORA-06512: at line 4
    ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
    ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190100", line 599
    ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 2486
    ORA-06512: at "APEX_190100.WWV_FLOW_DYNAMIC_EXEC", line 1476
    ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 1351

  • error_statement:

    SELECT * FROM (SELECT CTY.OID
    , CTY_NAME AS "City Name"
    , CTRY.CTRY_NAME AS "Country Name"
    , CTY.POPULATION AS "Population"
    , CTY.CREATE_DATETIME AS "Created On"
    FROM FX_T_DEMO_CITY CTY
    INNER JOIN FX_T_DEMO_COUNTRY CTRY ON CTRY.OID = CTY.CTRY_OID) q WHERE IN ( SELECT regexp_substr(:FOEX_CTX_TEXT,'[^\:]+', 1, level) val FROM dual CONNECT BY regexp_substr(:FOEX_CTX_TEXT, '[^\:]+', 1, level) IS NOT NULL)

Comments

Processing

Post Details

Added on Apr 16 2020
#foex, #foex-bug
1 comment
477 views