PL/SQL Developer Hangs when describing a view

[michaeldias]

Hello,

I regularly use the find facility within the tool and find when that it hangs when including views for a particular user.

I have traced from another session and found that it hangs when describing a particular view.

I have run this in debug mode and have a debug.txt file I can send.

Michael

 

[Marco Kalter]

It hangs when describing the SQL of the view. Are any of the objects referenced in the view SQL invalid?

 

[michaeldias]

It was not marked as invalid in the dictionary tables but recompiling the view has fixed the problem.
Perhaps a timeout to skip over the object(s). The code appeared in the trace file so there should be enough information to bring back the object in the results pane if we match on search criteria.