Schema name not shown in correct location when saving a package script to file (4241055)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Schema name not shown in correct location when saving a package script to file
Description

When selecting the Schema Browser option 'Save to File' for a Package, the schema owner is sometimes not added to the Package name on the 'Create or Replace schema_owner .package_name' line.
Instead it is placed in the next occurence of 'package_name', at the end of the script.
e.g. It is now appearing as:

CREATE OR REPLACE PACKAGE BODY p_test
AS
gc_test CONSTANT VARCHAR2(30) := UPPER('SCHEMA_NAME.p_test');

instead of:
CREATE OR REPLACE PACKAGE BODY SCHEMA_NAME.p_test
AS
gc_test CONSTANT VARCHAR2(30) := UPPER('p_test');
Resolution

WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for Oracle
Defect ID

ST 74690
Additional Information

This is only occurring from Toad 10

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title