My Oracle Support Banner

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 to
Information in this document applies to any platform.


On Oracle Enterprise Metadata Management (OEMM) 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:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.