Database Utilities (MOSC)

MOSC Banner

Altered Objects' Generated DDL Incorrect

edited Jan 25, 2010 7:27PM in Database Utilities (MOSC) 4 commentsAnswered
 I'm using DBMS_METADATA to generate DDL for my schema. Some of the Object Types have ALTER statements because of the way they were modified over time. The generated statements for these composite objects are missing critical punctuation. For example:

CREATE OR REPLACE TYPE "MYTEST" IS OBJECT
(class_name VARCHAR2(32) )
 alter type        MYTEST modify attribute CLASS_NAME VARCHAR2(64) cascade
/

Should read:

CREATE OR REPLACE TYPE "MYTEST" IS OBJECT
(class_name VARCHAR2(32) );
/

 alter type        MYTEST modify attribute CLASS_NAME VARCHAR2(64) cascade
/

The generated DDL is missing the semicolon and forward slash after the CREATE OR REPLACE.

Is this a known bug? I thought I'd check here before logging one.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center