My Oracle Support Banner

Forward Chain Job Failed: : ORA-06502: Numeric Or Value Error: Character String Buffer Too Small (Doc ID 2423812.1)

Last updated on JULY 17, 2018

Applies to:

Oracle Life Sciences Data Hub - Version 2.4 to 2.4.7 [Release 2.4]
Information in this document applies to any platform.

Symptoms

When submitting a forward chain job, the customer is getting the below error.

It seems the buffer l_list_prrefs_assource should be a CLOB or simply give user warning message that too many depend objects in the chain.

  PROCEDURE CHAIN_FORWARD(
  pi_prref_id IN NUMBER,
  pi_prref_ver IN NUMBER
  )
  AS
  l_list_prrefs_assource VARCHAR2( 32000 );

ERROR
Error Code: -6502:: Error Description: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.CDR_EXE_FORWARDCHAIN", line 1129
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.CDR_EXE_FORWARDCHAIN", line 511

Changes

 

Cause

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

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


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