commit bd43c79a109ce3a4426c0c610022237d5b1ef7a3
author Mike Norman <michael.norman@oracle.com> Thu Mar 08 17:18:14 2012 -0500
committer Mike Norman <michael.norman@oracle.com> Thu Mar 08 17:18:14 2012 -0500
tree a5f059aa7b07ee231ad4843bdcb1fb8343102ea6
parent c7d0e98292bbe642912d184ec7b171983fd8e372

add check against STATUS column

oracleddlparser/src/main/java/org/eclipse/persistence/tools/oracleddl/util/DatabaseTypeBuilder.java

diff --git a/oracleddlparser/src/main/java/org/eclipse/persistence/tools/oracleddl/util/DatabaseTypeBuilder.java b/oracleddlparser/src/main/java/org/eclipse/persistence/tools/oracleddl/util/DatabaseTypeBuilder.java
index 47aab00..b116990 100644
--- a/oracleddlparser/src/main/java/org/eclipse/persistence/tools/oracleddl/util/DatabaseTypeBuilder.java
+++ b/oracleddlparser/src/main/java/org/eclipse/persistence/tools/oracleddl/util/DatabaseTypeBuilder.java
@@ -75,9 +75,9 @@
     public static final String DBMS_METADATA_GET_DDL_STMT_STMT2 =

         "REGEXP_LIKE(OWNER,?) AND";

     public static final String DBMS_METADATA_GET_DDL_STMT_STMT3 =

-        " OBJECT_TYPE = ? AND";

+        " AO.STATUS = 'VALID' AND AO.OBJECT_TYPE = ? AND";

     public static final String DBMS_METADATA_GET_DDL_STMT_SUFFIX =

-        " OBJECT_NAME LIKE ?";

+        " AO.OBJECT_NAME LIKE ?";

     //OBJECT_TYPE codes from ALL_OBJECTS view - we are only interested in top-level types:

     public static final int OBJECT_TYPE_UNKNOWN_CODE = -1;

     public static final String ALL_OBJECTS_OBJECT_TYPE_FIELD = "OBJECT_TYPE";