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

Last updated on AUGUST 22, 2019

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 '/<DIR>/<DIR>/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 '<SID>/TEST_XXXXX/FN_XXXX'. 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.