Error Message :
The following errors appear on the job log:
ORA-06502: PL/SQL: numeric or value error: host bind array too small
ORA-06512: at line 1
Patch level detected:Dollar Universe 6.2.01
Product Version: Dollar.Universe 6.2.01
Description :Some OAPP_SET Jobs abort with the following message in the job log:
"ERROR: ORA-06502: PL/SQL: numeric or value error: host bind array too small"
Root Cause: This problem can appear for two reasons:
1. The UTL_FILE package is not correctly configured to work with Dollar Universe. The package UTL_FILE is based on a directory alias defined on the database.
For the first reason, the solution is to modify the alias used by Dollar Universe ( variable UXOAPP_DIR_OUT_ALIAS on the values.xml).
In case the database server is remote, then you should add the following variable on the values.xml:
For the second reason, the solution is to modify the PATH and LD_LIBRARY_PATH so they point to a version 11g or superior of sqlplus.
In order to do that, add these three lines at the end of the file /data/nodefiles/unienv_oapp_specific.ksh in order to point to the client 11g:
Fix Status: Released
Version: Dollar.Universe 6.2.01