My Oracle Support Banner

Enabling Queue set up having selection criteria more than 2000 characters: SQLORA-06502: PL/SQL: numeric or value error: character string buffer too small: OFSLLREL.QCSPRC_EN_100_01 (Doc ID 2731281.1)

Last updated on NOVEMBER 28, 2020

Applies to:

Oracle Financial Services Lending and Leasing - Version 14.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

While enabling the queue set up with selection criteria having 2000 characters, system fails with error. 


ERROR
-----------------------
 Ora Error Msg : ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  Context : Error in : qcsprc_en_100_01.Prepare_SQLORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at "OFSLLREL.QCSPRC_EN_100_01", line 362
  Context : Error in : qcsprc_en_100_01.get_sql
  Context : Error in : qcsprc_em_100_01.qcsprc_em_100_01
  Context : Error in : qcsprc_ew_100_01.qcsprc_ew_100_01 QUERY_ONLY CORRESPONDENCE CORRESPONDENCE
  Context : Error in : uquprc_el_100_02.get_sql
  Context : uquasg_el_100_01.post_upd

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users not able to configure new queue with selection criteria having more than 2000 characters

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!


In this Document
Symptoms
Changes
Cause
Solution


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