Designer Extended Copy Fails With Errors RME-2105 ORA-6550 PLS-103 RME-2124 (Doc ID 254807.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Repository - Version: 6.5 and later   [Release: Designer 6i and later ]
Oracle Designer - Version: 6.5 and later    [Release: Designer 6i and later]
Information in this document applies to any platform.
Repository Object Navigator (RON) : Utilities - Extended Copy

Symptoms

"Extended Copy" fails with the following error messages:

RME-02105: Oracle error occurred...
ORA-06550: line 1, column 21:
PLS-00103: Encountered the symbol "CASE" when expecting one of the following:
( - + mod not null
  avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date

 
The symbol " was inserted before "CASE" to continue.
ORA-06550: line 1, column 55:
PLS-00103: Encountered the symbol "CASE" when expecting one of the following:
( - + mod not null
  avg
count current exists max min prior sql stddev sum vari
ORA-06550: line 1, column 88:
PLS-00103: Encountered the symbol "CASE" when expecting one of the following:
( - + mod not null
  avg
count current exists max min prior sql stddev sum vari
RME-02124: Failed to execute SQL statement: BEGIN
:elem_ivids:=CASE.jr_num_list(); :elem_types:=CASE.jr_num_list(); :check_el :=CASE.jr_str_list();END;

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