ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Document ID : KB000088326
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Resolution:

Symptoms

The following error is returned when trying to edit any OAE job or process flow that containf OAE jobs.

Data Types missing, Please import : OAE_OBJS : java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPWORX_DEV.AWAPI", line 533 

 

 


 

Cause

The problem is that the OAE data types are missing.

 


 

Resolution

Import the OAE_OBJS. The file can can be found in the $AW_HOME/import directory of the master. The file is named OAE_OBJS.exp