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 12.2.1.2 and later
Information in this document applies to any platform.

Symptoms

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

For example:

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

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

end;

 

[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-12.2.1.2.0-20180122/OracleMetadataManagement/tomcat/bin/../../tomcat/../java/Jdbc/oracle'
[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

Cause

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