Changing Property Of A Column In A Foreign Key Constraint Rme-00020 (Doc ID 264233.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Designer - Version: 6.5.94.3 and later   [Release: Designer 6i and later ]
Oracle Designer - Version: 9.0.2 and later    [Release: Designer 9i and later]
Oracle Designer - Version: 9.0.4.3 and later    [Release: Designer 10g and later]
Information in this document applies to any platform.

Symptoms

When using long table and column names it can occur that updating the property
'optional' of a column results in following error:

RME-00020: Internal API error - ORA-06502: PL/SQL: numeric or value error:
character string buffer too small
RME-00011: Operation 'close' on ACTIVITY has failed
RME-00222: Failed to dispatch operation to Repository
RME-00224: Failed to close activity

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