My Oracle Support Banner

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 MARCH 07, 2022

Applies to:

Oracle Quality - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version,

When attempting to create a collection procedure, the following error occurs.

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.

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.




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

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