IMP-00003 / ORA-06550 / PLS-00103 while exporting DBMS_SCHEDULER Job (Doc ID 1158473.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.1.0 - Release: 10.1 to 11.2
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.1.0.3   [Release: 10.1 to 10.1]
Information in this document applies to any platform.

Symptoms

"BEGIN "
"dbms_scheduler.create_job('"TESTJOB"',"
"job_type=>'PLSQL_BLOCK', job_action=>"
"'begin insert into t ( s ) values (to_char(sysdate,'DD.MM.YYYY HH24:MI')); "
"commit; end;'"
", number_of_arguments=>0,"
"start_date=>'12.07.10 09:54:01.000000 +02:00', repeat_interval=> "
"'FREQ=MINUTELY;INTERVAL=1'"
", end_date=>NULL,"
"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments="
">"
"NULL"
");"
"dbms_scheduler.enable('"TESTJOB"');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 4, column 53:
PLS-00103: Encountered the symbol "DD" when expecting one of the following:
...








Changes

The issue occur when the export dump file was created by one of the following releases:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms