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:
Oracle Communications MetaSolv Solution - Version 6.0.16 and laterInformation in this document applies to any platform.
*** Reviewed for relevance on 26-FEB-2019 ***
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
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 |
Cause |
Solution |
References |