Error in Batch Job Sdbp_Job_Error_Log- ORA-06502: PL/SQL Numeric or Value Error: Character String Buffer too Small (Doc ID 1517723.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Symptoms

The Batch job sdbp_job_error_log displays the following error:

ERROR: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The issue can be reproduced at will with the following steps:
1. Job Error Log is a stand alone job that sends an alert to a specified user when an error or a warning is encountered after running a job. Set up the following job in the Job Manager module:

job sdbp_job_error_log (x, y, sysdate-z);

where x = is the job number, y is the plant and z specifies the number of days, usually 1, to be
deducted from the current date.

2. Change the pre-existing jobs that are to be monitored for error logging - For example RUN ALL BATCH

BEGIN

SDBP_RUN_ALL_BATCH(81,'01');--ALERT=['USERNAME']

END;

The statement in the BEGIN-END clause tells the system which job needs to be executed. The string --ALERT=['USERNAME'] tells the application who to send the alert/email to if an error or warning is encountered. The user will receive an alert and/or e-mail notification, depending on user profile settings. The string --ALERT=[''] MUST EXIST for an alert/email to be sent to the indicated username.

3. Run the Batch job
4. Run Job Error Log Batch job
5. Check the log for Job Error Log - Error will be displayed

Cause

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