Edit Type Bug - Subtypes

[townsendEbmud]

For a Type, choosing Edit from the Object Browser context menu produces incomplete DDL when the type is a subtype. Example: We have a DOX_CN type. From the context menu, the first line in the editor is:

CREATE OR REPLACE TYPE "DOX_CN"

However, if you choose dbms_metadata/DDL from the context menu, the first line is:

CREATE OR REPLACE TYPE "TYP"."DOX_CN" under ebm_cn (

PL/SQL Developer is missing: under ebm_cn (

This produces invalid code for editing and can easily lead to turning a subtype into a type by accident.

 

[townsendEbmud]

Never mind. The missing code was just so far off the right side of the screen that it was not visible at first.