Oracle Application Express
|Return to 2.2 Archive|
|Developer Alert: Bug after upgrade to 2.2/2.2.1|
|Applications upgraded to 2.2/2.2.1 having page items with a certain combination of attributes will fail at runtime with an error resembling:
ORA-06502: PL/SQL: numeric or value error Error ERR-1019 Error computing item default value: page=1 name=P1_SEQ. OKThe item that causes this (named in the message) will have the Item Source=SQL Query but the Source attribute will be null. To correct this, edit the item and change Item Source to Static. After an upgrade, you can locate items that have these properties within your workspace using this query:
select workspace,application_id,page_id,item_name from apex_application_page_items where item_source_type='SQL Query' and item_source is null order by 1,2,3 /Before or after an upgrade, you can locate items that have these properties in all workspaces using this query:
select flow_id||':'||flow_step_id||':'||name from wwv_flow_step_items where source_type='QUERY' and source is null order by flow_id,flow_step_id /That query would be run from SQL*Plus as the FLOWS_xxxxxx schema for either the pre- or post-upgraded version.