My Oracle Support Banner

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:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.


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




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


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.