1 Reply Latest reply: Jun 22, 2014 2:53 PM by Richard Legge RSS

    Sample Application

    Richard Legge

      Quick one hopefully..

       

      APEX 4.2.4

      I have installed the sample application. "Sample Forms and Grid Layout" and it runs perfectly fine. However I'm trying to copy and run page8 (Filterable Tabular fForms) to my application. Same workspace, same schema etc.

       

      When I try and run it I get an eror when the PL/SQL Build Filter Collection page process tries to execute.

       

      ORA-06502: PL/SQL: numeric or value error

      http://192.168.0.86:8090/i/htmldb/builder/rollup_minus_dgray.gifTechnical Info (only visible for developers)

      • is_internal_error: false
      • ora_sqlcode: -6502
      • ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error
      • component.type: APEX_APPLICATION_PAGE_PROCESS
      • component.id: 6339301484050862
      • component.name: Build Filter Collection
      • error_backtrace: ORA-06512: at "VRS.EBA_DEMO_TF_FILTER_FW", line 471 ORA-06512: at "VRS.EBA_DEMO_TF_FILTER_FW", line 58 ORA-06512: at line 31 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1065 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1091 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 832 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 139

      Ive confirmed that I can see the package in my schema etc. I've checked page processes, global variables etc..

       

      Any ideas?

      Rgds

      Richard