I recently ran into an issue with the “Save Package Spec and Body” where I was getting empty files. I did a little digging into the logging and found that the command uses DBA_SOURCE. Ran the query independently and I do not have access to DBA_SOURCE with some accounts which explains why the file is empty.
I can view the package spec/body in the editor and I can also export the files using Quick DDL → Save to File with the problematic user.
I swear this used to work just fine and I'm not sure if my DBAs made a change to the permissions on the user I'm accessing or if this happened with a recent move to a more recent SQL developer version. I searched preferences and didn't see anywhere to change the setting from DBA_SOURCE to ALL_SOURCE which I do have access to. Any suggestions for this issue? I have a work-around with Quick DDL but it's nicer to the spec and body in one file.
SQL Dev Version: 22.2.1.234
DB Version: 19.20.0.0.0