Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Developer hangs on "comparing subprograms"

GregVJul 30 2019 — edited Jan 13 2020

Hi,

My SQL Developer is 19.1.

I'm navigating from one package to another because of many nested references, and time to time SQL Developer hangs on "comparing subprograms", such as the one shown in the example below:

pastedImage_0.png

I don't know why it's comparing, but it causes SQL Developer to completely hang, freeze, or even "blink", disappearing from the taskbar and reappearing, and the only solution I have is to Ctrl+Alt+Del SQL Developer, losing all the open package body I had.

pastedImage_1.png

That being said, it would nice to have a "restore" options to retrieve all my pages that were open at the time of the crash.

Thanks

Comments

Processing

Post Details

Added on Jul 30 2019
#sql-developer
8 comments
7,626 views