plsqldoc not link db objects when file/directory objects changed

[aaronh97]

For the plsqldoc pug in we are trying to get the documentation for a package and the documation for a table to cross-reference correctly. It works fine when the filename, subdirectories, and object name prefix in the configuration have all options checked. However we want to do this with only the owner checked under subdirectories. When we do this we get a bogus link to the previous setup or plsqldoc does not treat the table name in the comments as a cross-reference.

We have the global option checked for cross references. We also make sure to generate the documentation for the table before the package.

Currently we are using the latest version with frames.

 

[Marco Kalter]

I can indeed reproduce this issue, and we are looking into this.

 

[Marco Kalter]

I have found a possible problem that could cause this. When you switch preferences, cached files can cause these wrong links. You should be able to correct things when you regenerate the file(s) with the wrong links and/or rebuild the index.

Let me know how this turned out.

 

[aaronh97]

We tried this but it still does not work. plsqldoc still does not recognize the table name and link it. I even tried deleting all documentation and the index before regenerating but it didn't work. We also tried shutting down plsql developer and restarting to eliminate any caching of preferences, but ended up getting bogus links or no links at all.

If we put all the preferences back to having everything checked then the links will work again, but this isn't really how we want it setup. We would like to hide the database name from the developers(we have many more environments than they do) and want to only include the schema names.

 

[agent86]

My preference would be to have only "owner" checked under "Subdirectories". Any other combination results in bogus links. Although "Filename prefix" has no effect. All options under "Subdirectories" and "Object name prefix" must be checked to get cross-referencing links working correctly.

Aaron

 

[agent86]

I found out how to get it working with only owner checked under subdirectories. Still must have *both* items checked under object name prefix.

Start with it working:

1. database and owner checked under subdirectories.
2. database and owner checked under object name prefix.
3. uncheck database under subdirectories. You will be prompted to delete all files.
4. Regenerate docs.
5. BROKEN. Links wont work now.
6. Rollback (recheck database under subdirectories).
7. Regenerate docs.
8. BROKEN. Links still wont work.

Solution (mainly the addition of 3a and 6a):

1. database and owner checked under subdirectories.
2. database and owner checked under object name prefix.
3. uncheck database under subdirectories. You will be prompted to delete all files.
3a. EXIT pl/sql developer and restart.
4. Regenerate docs.
5. WORKS. Links work now.
6. Rollback (recheck database under subdirectories).
6a. EXIT pl/sql developer and restart.
7. WORKS. Links work now.

Still would be nice not to have both database and owner checked under object name prefix.

Aaron