Has anyone encountered ORA-06502 using Webutil after in-place F&R upgrade from 12.2.1.4.0 to 12.1.19
Oracle Weblogic 12.2.1.4.0 w/Forms & Report (F&R) 12.2.1.19 Webutil is giving ORA-06502 error after "In-Place" upgrade from F&R 12.2.1.4.0.
Oracle form using Webutil worked fine with Oracle F&R 12.2.1.4.0 when using functionality to open single file and read contents from client system. After in-place upgrade to Oracle F&R 12.2.1.19, getting ORA-06502 errors after several text line records (ex. 2 of 36) are transferred from client. Some text line records in the file exceed 5000 characters.
Checks:
a) Reviewed Oracle Support document "Webutil File Upload of Files Larger Than 5k Fails (Doc ID 2996152.1)" and ensured its steps were followed
b) Ran F&R 12.2.1.19 create_webutil_db.sql package ran from ORACLE_HOME/forms to successfully create database WEBUTIL_DB package