Forum Stats

  • 3,783,020 Users
  • 2,254,720 Discussions
  • 7,880,246 Comments

Discussions

How to prevent SQL developer from freezing the interface when editing long pl/sql code

user7091240
user7091240 Member Posts: 49 Green Ribbon

When I edit or modify the code of long PL/SQL program (package, function or procedure), the editor interface in SQL developer will show text 'comparing xxx subprograms' and a back-forth moving blue flash in a rectangle block.

When this happens, the editor is frozen, and I can not do anything, and have to wait for several seconds, and the longer the code, the longer the wait time.

Is there any trick to disable this behavior?

If it is inevitable, is there anyway to reduce the wait time?

Answers