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: to - Release: 10.1 to 11.2
Oracle Server - Enterprise Edition - Version: to   [Release: 10.1 to 10.1]
Information in this document applies to any platform.


"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=> "
", end_date=>NULL,"
"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments="
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 4, column 53:
PLS-00103: Encountered the symbol "DD" when expecting one of the following:


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


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