Plugin Dependency Viewer

[Buzz_ss]

Hi

The new plugin DependencyViewer are availabled for download

----------------------
Dependency viewer provides a flexible tool to find usages of functions, procedures, types,
variables, tables etc... in PL source code.

"Search for Usages" dialog box can be activated from:

The context menu of the Object browser.
The context menu of the program window.

To open the Search for Usages window
1. Right-click an element and choose "Search for Usages" on the context menu.
The Search for Usages dialog box opens with the selected element shown in the Element to search for field.
2. In the Search for Usages dialog box, set options as required.
3. Click Search.
After searching the "Usages" window will open.

The "Usages" window shows the search results as a tree view.
Clicking a node containing an element opens the Editor in PL/SQL Developer
and places the cursor on the code with this usage of the element.

A few examples :

Spoiler

https://picua.org/image/ydAZWNhttps://picua.org/image/ydACPXhttps://picua.org/image/ydK7LJ

Requirements
Oracle 11g or higher
PL/SQL Developer(32 bit) version 11 or higher
----------------

 

[Nicolas D.]

Are you planning to offer a 64 bits version?
We are getting away from 32 bits

 

[Buzz_ss]

64bit is not ready now.
I hope in about a month I can offer it

 

[Arky]

Hello Buzz!

I seem to get the following error on every usage of the plugin

Error: Can not get connect to THEUSER@192.168.56.102:1521/orcl
Error while trying to retrieve text for error ORA-12557

I'm using latest 32 bit 14.0 version

Thank you in advance
Aris

 

[Buzz_ss]

Hello Arky.

Unfortunately, I can't reproduce this situation, but....
It seems the problem occurs when You have installed 32 bit and 64 bit oracle client on same computer. To solve this issue You can try to define TNS_ADMIN environment variable.

As example :http://www.dba-oracle.com/t_windows_TNS_ADMIN_environment_variable.htm

I will think about a more suitable solution...

Thanks for your feedback.

 

[Buzz_ss]

Hi

Now 64 bit version is availabled for download

Spoiler

 

[Buzz_ss]

Hi.
A new version of Dependency Viewer available here download
2 bugs are fixed in it.
a) Sometimes search worked incorrectly in jobs. Fixed.
b) "Open if PL/SQL" worked for the first search result in the object only. Fixed.

Greetings.

 

[Nicolas D.]

Hi,

Look like a bug somewhere.
When I search for a PACKAGE or TYPE, there is no issue looking in others packages or types
But if I search for a TABLE, it do not search in package -- I get the list of TRIGGERS, SYNONYMS, ... but not in PACKAGES nor TYPES. Same for a VIEW, it doesn't look into PACKAGE or TYPE code.

Edit: Found out that the issue is related to the fact the table are not in the same schema, but visible here as SYNONYMS... When you search for usage over the synonym name, it try to search using the original table name and schema instead. Which lead to the object being not found as we never refer to the name of the schema owning the table, only to synonyms.

Also, extra suggestion: when searching a table, could you also search for foreign key constraints referencing the table? it would be nice to have (good to see all dependencies in one place.. I know we can get it others way, but just more convenient to see all in the same window)

 

[pavel_j]

Hi,

thanks for this plugin. It's really missing feature in plsql developer.
I have some points (bugs?)

1. I assigned key to "Search Usages" to Ctrl+Alt+H, if I use this key on some function, in "search for usages" dialog there is missing function name, if I use right mouse clict + Search for usages on the same function from context menu there is corrent function name prepared for searching.

2. It seems that searching is not working from TYPES on MEMBER function or MEMBER Procedure now ....

Version of plugin: 1.0.1.410

 

[Buzz_ss]

Hi,Nicolas

When I search for a PACKAGE or TYPE, there is no issue looking in others packages or types
But if I search for a TABLE, it do not search in package -- I get the list of TRIGGERS, SYNONYMS, ... but not in PACKAGES nor TYPES. Same for a VIEW, it doesn't look into PACKAGE or TYPE code.

It seems plugin works correctly. When Your package uses table directly, plugin shows it in results form. When package uses table through synonym, plugin doesn't show it. Plugin shows synonym only! But You can call the search for this synonym directly in results form. After that You'll get required result.

Also, extra suggestion: when searching a table, could you also search for foreign key constraints referencing the table? it would be nice to have (good to see all dependencies in one place.. I know we can get it others way, but just more convenient to see all in the same window)

Thanks for Your suggestion. I'll think about it and maybe it will be done in future versions

Greetings

 

[Buzz_ss]

Hi, Pavel.

1. I assigned key to "Search Usages" to Ctrl+Alt+H, if I use this key on some function, in "search for usages" dialog there is missing function name, if I use right mouse clict + Search for usages on the same function from context menu there is corrent function name prepared for searching.

This is not bug. This is because You can't assign hot key to Popup menu. You assign it to main menu item. In this case, PLD does not tell me about the details of the object.
I only know your current window. Maybe later I'll think of something...

2. It seems that searching is not working from TYPES on MEMBER function or MEMBER Procedure now ....

Ups... It seems wrong. I'll investigate it.
For now, use the whole object search.

Thanks
Greetings