When I select the option to 'Save To File' in an existing package, the schema owner name is not saved to the file that is created.
1. Open Schema Browser and browse to a package.
2. Right-click the package and select Save To File | Save Body Only from the sub-menu.
3. Save the package body (.pkg) to the desktop.
4. Open the file in Notepad or via the Toad Editor and the schema owner name in the package body script is missing.
i.e. CREATE OR REPLACE PACKAGE "Package_Example" - Expecting to see CREATE OR REPLACE PACKAGE "schema1.Package_Example"
NOTE: In the Toad Options, I have the following set:
In View | Toad Options | Editor - Open\Save, the Owner name is set to 'Always include'.
Double quotes are currently surrounded for the package body.
Remove the double quotes surrounding the package body name. Removing the double quotes around the package body name will prepend the Schema Owner name to the front.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center