PLSQL files are not reparsed on some occasional code changes

guesxy

Member
Hi, just will give you a quick overview of a scenario I saw. While having a PLSQL file opened (a package body to be precise), sometimes when adding code to it via copy paste (in my case exception handling block that is similar in some functions), the file content tree (which lists procedures and functions on the left) gets invalid and stops working properly, ie becomes somewhat usable. I take it the file is not properly reparsed, or that left side if not based on the file contents and depends on Oracle dictionary? Either way its a mild issue solved by recompiling the package, though though to let you know :)
 
If you modify the source and it becomes temporarily invalid (e.g. you start to write an "if" statement and the corresponding "end if" is not yet present) then the Code Contents will be marked as invalid until you complete the modification.
 
That is fine, and works accordingly. My case is based on copy paste of an EXCEPTION block into a procedure/function that had none. The code is VALID at the time of copying, still the package tree is becoming corrupt. Also this is for v11 (didnt try on previous versions)
 
Back
Top