My Oracle Support Banner

Cannot Create Lane Using Too Long Location ID, Error ORA-06502: PL/SQL: numeric or value error (Doc ID 556043.1)

Last updated on MARCH 20, 2019

Applies to:

Oracle Transportation Management - Version 5.5.03.04 to 5.5.03.05 [Release 5.5]
Information in this document applies to any platform.
Checked for relevance on 27-May-2010


Symptoms


On 5.5.03.04:
When trying to create lane with long location ID in Russian (actually it is still in the normal character size which is 101 character) the lane definition is not saving and the following error is shown:
ERROR
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too
small ORA-06512: at "GLOGOWNER.RRL", line 266 ORA-06512: at "GLOGOWNER.RRL", line 290 ORA-06512: at "GLOGOWNER.X_LANE_AIU", line 30 ORA-04088: error during execution of trigger
'GLOGOWNER.X_LANE_AIU'

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:

1- Go to Transportation Planning and Execution > Power Data > Geography > Lane Definition
> New > Give it an ID and select "Location" for both source and destination > Click on "Lane Definitions"

Use:
Source: ÏÎÐÒ ÑÀÍÊÒ-ÏÅÒÅÐÁÓÐÃ
Destination: ÑÂÕ ÎÀÎ ÏÅÒÐÎËÅÑÏÎÐÒ

Then click Finish > Here you will get the error


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

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