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"
Cause type: Other 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: Y
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: