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 APRIL 08, 2021
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:
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