Functions Having Parameters with Complex Datatype Format are Ignored
(Doc ID 2374112.1)
Last updated on APRIL 04, 2019
Applies to:
Oracle Enterprise Metadata Management - Version 12.2.1.2 and laterInformation 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 '/<DIR>/<DIR>/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 '<SID>/TEST_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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |