OEMM Oracle Database (via JDBC) Bridge Fails to Import a Database View When the View TEXT_LENGTH is Greater Than 32768 Characters
Last updated on OCTOBER 03, 2017
Applies to:Oracle Enterprise Metadata Management - Version 220.127.116.11 to 18.104.22.168
Information in this document applies to any platform.
On Oracle Enterprise Metadata Management (OEMM) 22.214.171.124 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:
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