DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE fails with ORA-6502: PL/SQL: numeric or value error (Doc ID 3044544.1)

Last updated on SEPTEMBER 07, 2024

Applies to:

Goal

DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE fails with ORA-6502: PL/SQL: numeric or value error

DECLARE
evolve_out CLOB;
BEGIN
evolve_out := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE ( SQL_HANDLE => 'SQL_0a02f86664a5f000' );
dbms_output.put_line(evolve_out);
END;
Error report -
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 5
06502. 00000 - "PL/SQL: numeric or value error%s"
*Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
*Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.

Solution

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