OIM 12c Bulk Load Utility Failing with "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" (Doc ID 2622962.1)

Last updated on AUGUST 02, 2021

Applies to:

Symptoms

Executing OIM Bulk load utility on 12c environment.
It returns buffer error

ERROR
-----------------------
"Exception table name :BLK_LOAD_USER_INPUT_SOURCE_TABLE1
Exception in thread "main" java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "XXXXXX.OIM_BLKLD_PKG_USR", line 325
ORA-06512: at line 1

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
  at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4714)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
  at bulkload.UserLoad.createExTable(UserLoad.java:893)
  at bulkload.UserLoad.inputDBTable(UserLoad.java:762)
  at bulkload.UserLoad.showSubMenu(UserLoad.java:96)
  at bulkload.UserLoad.main(UserLoad.java:1019) "




 

Cause

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