ORA-27452 Error Creating Scheduler Job

When I create a job scheduler to perform a maintenance task gives me the following error.

ERROR at line 1:
ORA-27452: JOB _ / \ / \ / _ 10 is an invalid name for a database object.
ORA-06512: at “SYS.DBMS_ISCHED”, line 124
ORA-06512: at “SYS.DBMS_SCHEDULER”, line 271
ORA-06512: at line 2

In this case, the problem is in the string / \ / \ / (AN, my initials), have a habit of putting it to identify my things. Removing the “ANR” works. Another option is to use double quote in the definition of the job, as in the following example;

BEGIN
  DBMS_SCHEDULER.create_job (
    job_name        => '"JOB_/\/\_15"',
    job_type        => 'PLSQL_BLOCK',
    job_action      => 'BEGIN NULL; END;',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'freq=hourly; byminute=0; bysecond=0;',
    end_date        => NULL,
    enabled         => TRUE,
    comments        => 'Job de prueba /\/\/.');
END;
/

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s