The Schema Browser "Save to File" saves only package body.
Steps to replicate the issue:
1. Select the "Automatically combine spec/body when saving object to file" in the option under View | Option | Editor | Open/Save.
2. Select the "Show Body when Package Name is Selected " in the View | Option | Schema Browser | Data.
3. In the Schema Browser, select a Package, right-click and select Save to File.
This will save only saves the package body. If I do not have the "Show Body when Package Name is Selected "selected, then it will save the package spec and body as expected.
WORKAROUND 1:
Right click on the package and select Save to file | Save.
WORKAROUND 2:
Right click on package and select Create Script. Under Objects & Output tab, check "One file per object". Then go to the Script Options tab | Packages tab.Check the options 'Extract both spec and body when only one is selected in objects grid' and 'Always keep spec and body in the same file or editor tab'. Specify the location where you want the script created and Click on the "OK" button.
STATUS:
This issue is fixed in TOAD 11.5. The latest version of Toad for Oracle can be downloaded here.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center