Error Message: ‘SP_TGUD ORA-06502: PL/SQL: numeric or value error: character string buffer too small when selecting Values for Trunks (Doc ID 1994584.1)

Last updated on JULY 26, 2023

Applies to:

Symptoms

MetaSolv Solution version 6.2.1

PROBLEM DESCRIPTION  

The application throws a "SP_TGUD ORA-06502: PL/SQL: numeric or value error: character string buffer too small" error when attempting to view Trunk Group User Data from the Customer Account > Customer Services window for a Trunk Product that has a large number of trunks (approximately 30-40).

Recreation Steps

1. Search for in-service customer accounts with B ISDN trunk group product.
2. Go to customer account search window and search the Account number.
3. Open the customer summary page. Under the tab Related pages Click "SERVICES."
4. In the customer services page Click the B ISDN PRI trunk product under the service location and in the right side pane choose ALL as option in the drop down In service values.
5. Once selected we receive the error message as 'SP_TGUD ORA-06502: PL/SQL: numeric or value error: character string buffer too small'.

Cause

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