APEX Package WWV_FLOW.ACCEPT Errors with ORA-06502: PL/SQL: numeric or value error: character string buffer too small When Using OHS / Mod_plsql (Doc ID 2439946.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Symptoms

APEX has been upgraded, and a new 11.1.1.9 Oracle HTTP Server (OHS) has been created. The APEX applications are all running successfully, however some actions within the APEX tool are failing with: 

The requested URL /pls/apex/wwv.flow.accept NOT found

This error occurs when editing a region's source for an application page, and when editing the page alias and page name for an application.

The corresponding error in the OHS error log (ohs1.log) are: 
[2018-07-17T10:43:44.4753-05:00] [OHS] [ERROR:32] [OHS-9999] [core.c] [client_id: xx.xxx.xx.xxx] [host_id: dtemwb02] [host_addr: xxx.xx.xx.xxx] [tid: 26] [user: root] [ecid: <ECID>] [rid: 0] [VirtualHost: main] MODPLSQL-00261: mod_plsql: /pls/apex/wwv_flow.accept HTTP-404 Failed to execute target procedure ORA-00604: error occurred at recursive SQL level 1\nORA-06502: PL/SQL: numeric or value error: character string buffer too small\nORA-06512: at line 27\nORA-06550: line 33, column 3:\nPLS-00306: wrong number or types of arguments in call to 'ACCEPT'\nORA-06550: line 33, column 3:\nPL/SQL: Statement ignored\n, referer: http://<HOSTNAME>/pls/apex/f?p=4000:4301:2740162577671:::4301:F4000_P4301_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID:1,105,1

A standalone ORDS instance was created for diagnostic testing. The problem does not reproduce when using Oracle REST Data Services (ORDS) as the front end web server for APEX.

Other Details

• The actual APEX applications run without error. This includes the vendor applications and the home grown applications.
• The problem could not be reproduced internally with either 11.1.1.7 or with 11.1.1.9 version of OHS.
• Multiple databases and multiple OHS environments were tested at the customer site. The failure occurs consistently with OHS / mod_plsql regardless of environment.
• All third party software (load balancers, firewalls, etc.) was disabled / turned off. The problem still reproduces.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.