Error In GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP - ORA-6502 PL/SQL: numeric or value
(Doc ID 2093008.1)
Last updated on JUNE 11, 2018
Applies to:Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Quality Management Samples
Error in GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP - Standard Oracle API
Error ORA-6502 PL/SQL: numeric or value Error:number precision too large occurred in Package GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP at 025. Are calling gmd_results_pub.record_results API from custom Form. Identified that l_active_cnt this variable is having size 5. But from the query get a size 6. The query given below is causing the issue
WHERE sampling_event_id = l_sampling_event_id
FOR UPDATE OF disposition NOWAIT ;
The issue can be reproduced at will with the following steps:
1. Run API to record results and change disposition
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!