Function Having No Variable Declaration Between IS and BEGIN Are Ignored (Doc ID 2374114.1)

Last updated on NOVEMBER 21, 2018

Applies to:

Symptoms

On Oracle Enterprise Metadata Management (OEMM) 12.2.1.2, when there is no variable between the IS and BEGIN keywords, the entire function is ignored.

Error:

[Information] [2018-01-30 21:39:37]  Started operation: Import model version
[Information] [2018-01-30 21:39:38]  Loading jar files from '/refresh/home/app/oemm-12.2.1.2.0-20180122/OracleMetadataManagement/tomcat/bin/../../tomcat/../java/Jdbc/oracle'
[Information] [2018-01-30 21:39:40]  Loading metadata from 'Oracle'.
[Information] [2018-01-30 21:39:43]  Setting model properties
[Information] [2018-01-30 21:39:43]  Parsing stored procedures arguments...
[Warning] [2018-01-30 21:39:44]  Expression syntax not recognized (or not supported) for 'orcl/TEST_4181/FN_CONVERT'. Some lineage metadata will not be available. ---->>>>ERROR
[Information] [2018-01-30 21:39:44]  Import completed successfully <2018-01-30 21:39:44>
[Information] [2018-01-30 21:39:45]  Storing imported model to repository at: [-1,734] 2018-01-30 16:40:00 [Version]
[Information] [2018-01-30 21:39:46]  Operation completed.

Changes

Cause

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