Now update.database won't give errors when executing prescript in Oracle.
authorAntonio Moreno <antonio.moreno@openbravo.com>
Mon, 24 Nov 2008 11:19:06 +0000
changeset 2076 62ae1adc952c
parent 2075 27c053d06462
child 2077 1a0d02e15999
Now update.database won't give errors when executing prescript in Oracle.
src-db/database/model/prescript-Oracle.sql
--- a/src-db/database/model/prescript-Oracle.sql	Mon Nov 24 11:09:12 2008 +0000
+++ b/src-db/database/model/prescript-Oracle.sql	Mon Nov 24 11:19:06 2008 +0000
@@ -1,3 +1,15 @@
+Begin  
+  execute immediate 'Drop table C_TEMP_SELECTION';
+  Exception when others then null;
+End;
+/-- END
+
+Begin  
+  execute immediate 'Drop table C_TEMP_SELECTION2';
+  Exception when others then null;
+End;
+/-- END
+
  -- create temporary tables
  CREATE GLOBAL TEMPORARY TABLE C_TEMP_SELECTION
  (