My Oracle Support Banner

"6502ORA-06502: PL/SQL", Error During Customer Name Update Above 50 Character (Doc ID 2203640.1)

Last updated on MARCH 18, 2019

Applies to:

Oracle Common Applications Calendar - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

While updating the customer name above 50 character in CDH(R12.2.5), the name is updated. But while submission of Customer,
the following error occurs.

ERROR
-----------------------
"-6502ORA-06502: PL/SQL: numeric or value error: character string buffer too small. Please contact your system administrator".


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Search a customer
2. Updating the Organization Name of the customer,Save.
3. Again searching the customer. New organization name is reflecting.(Length of the string is 183 ).
4. Go to Confirm tab,Submit customer.
5. Error showing while submission of customer.

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
References


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