fix for Bug 212449- DTP vendor docs need to be refreshed with updates from WTP vendor docs
diff --git a/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_10/Oracle_10.xmi b/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_10/Oracle_10.xmi
index e44d7d0..d4045cf 100644
--- a/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_10/Oracle_10.xmi
+++ b/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_10/Oracle_10.xmi
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="ASCII"?>
-<DBDefinition:DatabaseVendorDefinition xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:DBDefinition="http:///org/eclipse/datatools/modelbase/dbdefinition/dbdefinition.ecore" vendor="Oracle" version="10" maximumIdentifierLength="8" snapshotViewSupported="true" viewTriggerSupported="true" maximumCommentLength="64" sequenceSupported="true" synonymSupported="true" mQTSupported="true" mQTIndexSupported="true" userDefinedTypeSupported="true">
+<DBDefinition:DatabaseVendorDefinition xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:DBDefinition="http:///org/eclipse/datatools/modelbase/dbdefinition/dbdefinition.ecore" vendor="Oracle" version="10" maximumIdentifierLength="8" snapshotViewSupported="true" viewTriggerSupported="true" maximumCommentLength="64" sequenceSupported="true" synonymSupported="true" mQTSupported="true" mQTIndexSupported="true" userDefinedTypeSupported="true" packageSupported="true">
<predefinedDataTypeDefinitions xmi:id="BINARY_1" lengthSupported="true" keyConstraintSupported="true" maximumLength="2000" primitiveType="BINARY" jdbcEnumType="-2" javaClassName="byte[]">
<defaultValueTypes>NULL</defaultValueTypes>
<name>RAW</name>
@@ -157,10 +157,12 @@
<languageType>C</languageType>
<procedureType>PROCEDURE</procedureType>
<procedureType>FUNCTION</procedureType>
+ <functionLanguageType>SQL</functionLanguageType>
+ <functionLanguageType>JAVA</functionLanguageType>
</storedProcedureDefinition>
<triggerDefinition whenClauseSupported="true" granularitySupported="true" referencesClauseSupported="true" perColumnUpdateTriggerSupported="true" insteadOfTriggerSupported="true" rowTriggerReferenceSupported="true" tableTriggerReferenceSupported="true"/>
<columnDefinition maximumIdentifierLength="30" computedSupported="true"/>
- <constraintDefinition maximumPrimaryKeyIdentifierLength="30" maximumForeignKeyIdentifierLength="30" maximumCheckConstraintIdentifierLength="30" clusteredUniqueConstraintSupported="true">
+ <constraintDefinition maximumPrimaryKeyIdentifierLength="30" maximumForeignKeyIdentifierLength="30" maximumCheckConstraintIdentifierLength="30" clusteredUniqueConstraintSupported="true" deferrableConstraintSupported="true">
<parentUpdateDRIRuleType>NO_ACTION</parentUpdateDRIRuleType>
<parentDeleteDRIRuleType>CASCADE</parentDeleteDRIRuleType>
<parentDeleteDRIRuleType>SET_NULL</parentDeleteDRIRuleType>
@@ -174,6 +176,7 @@
<viewDefinition maximumIdentifierLength="30"/>
<tableDefinition maximumIdentifierLength="30"/>
<schemaDefinition maximumIdentifierLength="30"/>
+ <udtDefinition maximumIdentifierLength="30" structuredTypeSupported="true"/>
<SQLSyntaxDefinition>
<keywords>A</keywords>
<keywords>ABORT</keywords>
diff --git a/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_8/Oracle_8.xmi b/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_8/Oracle_8.xmi
index 5b74ffd..7c8afcf 100644
--- a/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_8/Oracle_8.xmi
+++ b/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_8/Oracle_8.xmi
@@ -122,10 +122,12 @@
<languageType>C</languageType>
<procedureType>PROCEDURE</procedureType>
<procedureType>FUNCTION</procedureType>
+ <functionLanguageType>SQL</functionLanguageType>
+ <functionLanguageType>JAVA</functionLanguageType>
</storedProcedureDefinition>
<triggerDefinition whenClauseSupported="true" granularitySupported="true" referencesClauseSupported="true" perColumnUpdateTriggerSupported="true" insteadOfTriggerSupported="true" rowTriggerReferenceSupported="true" tableTriggerReferenceSupported="true"/>
<columnDefinition maximumIdentifierLength="30" computedSupported="true"/>
- <constraintDefinition maximumPrimaryKeyIdentifierLength="30" maximumForeignKeyIdentifierLength="30" maximumCheckConstraintIdentifierLength="30" clusteredUniqueConstraintSupported="true">
+ <constraintDefinition maximumPrimaryKeyIdentifierLength="30" maximumForeignKeyIdentifierLength="30" maximumCheckConstraintIdentifierLength="30" clusteredUniqueConstraintSupported="true" deferrableConstraintSupported="true">
<parentUpdateDRIRuleType>NO_ACTION</parentUpdateDRIRuleType>
<parentDeleteDRIRuleType>CASCADE</parentDeleteDRIRuleType>
<parentDeleteDRIRuleType>SET_NULL</parentDeleteDRIRuleType>
@@ -139,6 +141,7 @@
<viewDefinition maximumIdentifierLength="30"/>
<tableDefinition maximumIdentifierLength="30"/>
<schemaDefinition maximumIdentifierLength="30"/>
+ <udtDefinition maximumIdentifierLength="30" structuredTypeSupported="true"/>
<SQLSyntaxDefinition>
<keywords>A</keywords>
<keywords>ABORT</keywords>
diff --git a/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_9/Oracle_9.xmi b/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_9/Oracle_9.xmi
index fe3cdf7..fe41245 100644
--- a/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_9/Oracle_9.xmi
+++ b/plugins/org.eclipse.datatools.enablement.oracle.dbdefinition/runtime/vendors/Oracle_9/Oracle_9.xmi
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="ASCII"?>
-<DBDefinition:DatabaseVendorDefinition xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:DBDefinition="http:///org/eclipse/datatools/modelbase/dbdefinition/dbdefinition.ecore" vendor="Oracle" version="9" maximumIdentifierLength="8" snapshotViewSupported="true" viewTriggerSupported="true" maximumCommentLength="64" sequenceSupported="true" synonymSupported="true">
+<DBDefinition:DatabaseVendorDefinition xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:DBDefinition="http:///org/eclipse/datatools/modelbase/dbdefinition/dbdefinition.ecore" vendor="Oracle" version="9" maximumIdentifierLength="8" snapshotViewSupported="true" viewTriggerSupported="true" maximumCommentLength="64" sequenceSupported="true" synonymSupported="true" packageSupported="true" userDefinedTypeSupported="true">
<predefinedDataTypeDefinitions xmi:id="BINARY_1" lengthSupported="true" keyConstraintSupported="true" maximumLength="2000" primitiveType="BINARY" jdbcEnumType="-2" javaClassName="byte[]">
<defaultValueTypes>NULL</defaultValueTypes>
<name>RAW</name>
@@ -149,10 +149,12 @@
<languageType>C</languageType>
<procedureType>PROCEDURE</procedureType>
<procedureType>FUNCTION</procedureType>
+ <functionLanguageType>SQL</functionLanguageType>
+ <functionLanguageType>JAVA</functionLanguageType>
</storedProcedureDefinition>
<triggerDefinition whenClauseSupported="true" granularitySupported="true" referencesClauseSupported="true" perColumnUpdateTriggerSupported="true" insteadOfTriggerSupported="true" rowTriggerReferenceSupported="true" tableTriggerReferenceSupported="true"/>
<columnDefinition maximumIdentifierLength="30" computedSupported="true"/>
- <constraintDefinition maximumPrimaryKeyIdentifierLength="30" maximumForeignKeyIdentifierLength="30" maximumCheckConstraintIdentifierLength="30" clusteredUniqueConstraintSupported="true">
+ <constraintDefinition maximumPrimaryKeyIdentifierLength="30" maximumForeignKeyIdentifierLength="30" maximumCheckConstraintIdentifierLength="30" clusteredUniqueConstraintSupported="true" deferrableConstraintSupported="true">
<parentUpdateDRIRuleType>NO_ACTION</parentUpdateDRIRuleType>
<parentDeleteDRIRuleType>CASCADE</parentDeleteDRIRuleType>
<parentDeleteDRIRuleType>SET_NULL</parentDeleteDRIRuleType>
@@ -166,6 +168,7 @@
<viewDefinition maximumIdentifierLength="30"/>
<tableDefinition maximumIdentifierLength="30"/>
<schemaDefinition maximumIdentifierLength="30"/>
+ <udtDefinition maximumIdentifierLength="30" structuredTypeSupported="true"/>
<SQLSyntaxDefinition>
<keywords>A</keywords>
<keywords>ABORT</keywords>