IMPDP Fails With PLS-00103 When Importing Chain Step (Doc ID 1311970.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

When trying to import a dump file containing a scheduler chain, and with an evaluation interval specified for a chain step, the following error is raised:

Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
ORA-39083: Object type PROCOBJ failed to create with error:
ORA-06550: line 2, column 69:
PLS-00103: Encountered the symbol "00" when expecting one of the following:

) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || member submultiset
The symbol ", was inserted before "00" to continue.
Failing sql is:
BEGIN
dbms_scheduler.create_chain('"MY_CHAIN"', evaluation_interval=>+000 00:01:00, comments=>NULL
, rule_set_n

Changes

An evaluation interval has been specified for a particular chain step.

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