OEMM Oracle Database (via JDBC) Bridge Fails to Import a Database View When the View TEXT_LENGTH is Greater Than 32768 Characters

(Doc ID 2313485.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Enterprise Metadata Management - Version 12.2.1.1 to 12.2.1.1
Information in this document applies to any platform.

Symptoms

On Oracle Enterprise Metadata Management (OEMM) 12.2.1.1 version, when a TEXT_LENGTH for an Oracle Database View is greater than 32768, the Oracle Database (via JDBC) bridge does not harvest the entire view text. 

The import is not aborted and it completes successfully, but, the following messages are showed in the harvesting log:


When selecting the "View Statement" property in the OEMM Properties tab thru the OEMM web interface, it is possible to determine that the view text was cut off.

Below is snapshot of the "Properties" palette on the OEMM GUI interface where it is possible to verify the view text after the harvest into OEMM repository:




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