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'.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center