SQL Developer 23.x Not Generating Dependencies For Procedures When Run "Generate DB Doc" (Doc ID 3042015.1)

Last updated on AUGUST 18, 2024

Applies to:

Symptoms

On : 23.1 version, All Reports

ACTUAL BEHAVIOR

SQL Developer 23.x is not generating dependencies for Procedures when you run DB Doc.

For example, you have a table TEST and a procedure PROCEDURE1 created based on table TEST.
Using SQL Developer, you "Generate DB Doc".
When viewing the output of "Generate DB Doc", if select the table 'TEST' and then select dependencies, you can see procedure PROCEDURE1 in the list of dependencies.
However, if select the procedures --> PROCEDURE1 and then select dependencies, you do not see table 'TEST' in the list of dependencies.

In summary, you can see dependency to procedure when select “table”, but not other way around (that is, dependency to table when select procedure). Should the table to procedure dependency be both ways?

EXPECTED BEHAVIOR

To see dependencies of procedures when "Generate DB Doc".

STEPS TO REPRODUCE

The issue can be reproduced at will with the following steps:

1. Connected as user with SQL Developer 23.1.
2. Right click on connection name.
3. Select "Generate DB Doc" from context menu.
4. Click OK on entity select dialog.
5. Output automatically opens in default browse.

When viewing the output, if select the table TEST and then select dependencies, you can see procedure PROCEDURE1 in the list of dependencies.
When viewing the output, if select the procedures and select procedure1 and then select dependencies, you do not see table TEST in the list of dependencies.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.