Support lineage ingestion for Oracle Stored Procedures

[chuqbach]

Is your feature request related to a problem? Please describe.
We're using stored procedures heavily on our Oracle Data Warehouse for our ETL processes. Current Open Metadata version only support ingesting lineage from Oracle's View, so our logic/lineage in the Stored Procedure are not ingested and displayed. Therefore, if Open Metadata can support this feature, it will be really helpful to us (and other user working in Finance, Banking, Insurance industry, where Oracle Stored Procedure are used mainly).

Describe the solution you'd like
Open Metadata to ingest Stored Procedures on Oracle database and show a lineage between tables (or even column level) based on the Stored Procedure logic.

[NiharDoshi99]

Hi, I am working on this issue.

[nqvuong1998]

Hi @NiharDoshi99 @ayush-shah , Does Oracle Stored Procedures support Table Lineage?

[ayush-shah]

Yes @nqvuong1998 it does support table lineage, parsing the stored procedure and creating a lineage out of it.