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.
OK
The 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.