My Oracle Support Banner

Dbms_ilm.execute_ilm Fails With ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small (Doc ID 3015246.1)

Last updated on APRIL 22, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.19.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
dbms_ilm.execute_ilm fails with ORA-06502


While setting up ILM ADO on a partitioned table, the procedure dbms_ilm.execute_ilm fails with:


ORA-06502: PL/SQL: numeric or value error: character string buffer too small
----- Current SQL Statement for this session (sql_id=bkg9s6jsmnuub) -----
DECLARE
v_executionid number;
BEGIN
dbms_ilm.execute_ilm (ILM_SCOPE => dbms_ilm.SCOPE_SCHEMA,
execution_mode => dbms_ilm.ilm_execution_offline,
task_id => v_executionid);
dbms_output.put_line('TASKID='||v_executionid);
END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object line object
  handle number name
0x62972540 5170 package body SYS.PRVT_ILM.ILMJOBGROUP
0x62972540 6601 package body SYS.PRVT_ILM.EXECUTE_ILM_POLICIES
0x767c6688 483 package body SYS.DBMS_ILM.EXECUTE_ILM
0x62660390 4 anonymous block

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.