My Oracle Support Banner

Functions Having Parameters with Complex Datatype Format are Ignored (Doc ID 2374112.1)

Last updated on APRIL 02, 2018

Applies to:

Oracle Enterprise Metadata Management - Version and later
Information in this document applies to any platform.


On Oracle Enterprise Metadata Management (OEMM), when attempting to harvest procedure/function with parameter referencing %ROWTYPE, it is being ignored

For example:

create or replace procedure testproc(pTestTableRecord testtable%ROWTYPE)
insert into testtable values pTestTableRecord;

if pTestTableRecord.n>0 then
insert into testtable
select * from v_testtable_b;
end if;



[2018-02-06 22:58:16]  Started operation: Import model version
[Information] [2018-02-06 22:58:17]  Loading jar files from '/refresh/home/app/oemm-'
[Information] [2018-02-06 22:58:19]  Loading metadata from 'Oracle'.
[Information] [2018-02-06 22:58:54]  Setting model properties
[Information] [2018-02-06 22:58:55]  Determining lineage for views...
[Information] [2018-02-06 22:58:55]  Parsing stored procedures arguments...
[Warning] [2018-02-06 22:58:55]  Expression syntax not recognized (or not supported) for 'orcl/MDAVIES_2561/TESTPROC'. Some lineage metadata will not be available.
[Information] [2018-02-06 22:58:55]  Import completed successfully <2018-02-06 22:58:55>
[Information] [2018-02-06 22:58:57]  Storing imported model to repository at: [-1,774] 2018-02-06 17:59:13 [Version]
[Information] [2018-02-06 22:58:58]  Operation completed.


Unable to harvest the db model in production


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.