I’ve got a package with about 2500 lines of code stored in a file.
SQL-Navigator 6.0 shows the content of my file correctly.
If I want to compile the package (create or replace package body…), the last 200 lines of code are ignored.
My database-package shows only 2300 lines of code and is invalid.
With SQL-Navigator 5.5. everthing works fine:
2500 lines in my file, 2500 line in the compiled database-package, status: valid
This seems to be a bug in Nav 6.0 and makes it unusable for me.
I don’t think the issue is with the length of the script because we have packages that have more than 10 000 lines and they don’t have any issue. Maybe it contains some syntaxes that are not recognized by the 6.0 parser.
In order to find out the cause, I would need the ddl of the package you were using. However, if it’s not possible you can try downloading the beta release for 6.2 and see if it works in that version.