Length of the Name of a Quality Element With a Special Character Quote causes error " ORACLE error 6502 in FDPSTP"
(Doc ID 2835987.1)
Last updated on NOVEMBER 21, 2022
Applies to:
Oracle Quality - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version,
When attempting to create a collection procedure, the following error occurs.
ERROR
-----------------------
An error is generated by the automatic processing QLTSSCPB: Mapping of QA to AK.
ORACLE error 6502 in FDPSTP.
Cause: The execution of the FDPSTP routine failed due to ORA-06502: PL/SQL: numeric error or error on a value: string buffer too small
ORA-06512: at "QA_SSQR_JRAD_PKG", line 356.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Oracle Quality
2. Create Collection Plan element with a single quote in its name like (CONTROLE ESSAI D'UNE QUOTE) and add it in a plan.
3. The limit of the capacity of the field to be entered. In this case: 30 bytes.
4. Indeed, the quote counts as 5 characters. 26 normal characters + the quote makes the 30 accepted characters exceed.
IE "CONTROLE ESSAI D'UNE QUOTE" contains 26 characters. and the quote counts as 5 more.
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 |