Occaisiohally, when I’ve been doing a lot of editing in a large file, something happens to it so that I can no longer Skip to Top (using either the code editor button or shift+F7). It appears that the file gets corrupted in some way, because this behavior remains even after a full reboot. In the latest case the full file is 21,164 lines long, and skip to top goes to line 18,050.
I can scroll to the top manually, and can edit quite fine. However, when this happens it also won’t execute the file. In this case compile the package spec and the package body. Making this file, and a lot of time spent editing it, useless.
In the past I’ve eventually been able to recover an uncorrupted version of the file, but it’s not easy. Copying and pasting within SQL Nav doesn’t solve it, sine whatever the corruption/issue is seems to stick with the text. I’ve also tried copying and pasting to editors what can show whitespace characters, without success.
Peter S