My Oracle Support Banner

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 JULY 21, 2020

Applies to:

Identity Manager - Version and later
Information in this document applies to any platform.


Executing OIM Bulk load utility on 12c environment.
It returns buffer 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(
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(
  at oracle.jdbc.driver.T4C8Oall.doOALL(
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(
  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
  at oracle.jdbc.driver.OraclePreparedStatement.execute(
  at oracle.jdbc.driver.OracleCallableStatement.execute(
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(
  at bulkload.UserLoad.createExTable(
  at bulkload.UserLoad.inputDBTable(
  at bulkload.UserLoad.showSubMenu(
  at bulkload.UserLoad.main( "



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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