packages tree.set_coverage_id

tree.set_coverage_id

Repository spec: tree.set_coverage_id, body: tree.set_coverage_id

Signature (1)

PROCEDURE set_coverage_id (
    in_log_id       logs.log_id%TYPE        := NULL
);

Show code (19 lines)

PROCEDURE set_coverage_id (
    in_log_id       logs.log_id%TYPE        := NULL
) AS
    log_id          logs.log_id%TYPE;
BEGIN
    IF in_log_id IS NULL THEN
        SELECT MAX(TO_NUMBER(e.arguments)) INTO log_id
        FROM (
            SELECT e.action_name, e.flag, e.arguments
            FROM logs e
            CONNECT BY PRIOR e.log_id   = e.log_parent
            START WITH e.log_id         = tree.get_tree_id()
        ) e
        WHERE e.flag            = tree.flag_profiler
            AND e.action_name   = 'START_COVERAGE';
    END IF;
    --
    recent_coverage_id := COALESCE(log_id, in_log_id);
END;