search

open-metadata / OpenMetadata

OpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
https://open-metadata.org
Apache License 2.0
5.55k stars 1.05k forks source link

Oracle Stored Procedure lines #17920

Open KsM00000 opened 1 month ago

KsM00000 commented 1 month ago

Affected module We have a problem with our stored procedures in Oracle: the order of the procedure code lines is mixed up.

procedure

The procedure is valid when I check it in DB.

procedure_view

Describe the bug After some digging I found query that is used to get stored procedures.

SELECT
    OWNER,
    NAME,
    LINE,
    TEXT
FROM
    DBA_SOURCE
WHERE
    type = 'PROCEDURE' and owner = '{schema}'

And I think the problem is that there is no ORDER BY in query.

procedure2

The numbers in the column "line" are correct, but for some reason the order in which you receive them may differ.

Expected behavior Procedures with right code.

Version: