From 42cdbf617c6d0ef178266f5a3be2431c4f399dc4 Mon Sep 17 00:00:00 2001
From: Constantin Michael <constantin@codesynthesis.com>
Date: Fri, 18 Nov 2011 11:38:21 +0200
Subject: Simplify drop table SQL for Oracle

---
 view/driver.cxx | 9 +--------
 1 file changed, 1 insertion(+), 8 deletions(-)

(limited to 'view/driver.cxx')

diff --git a/view/driver.cxx b/view/driver.cxx
index b0b6c4a..5e6a131 100644
--- a/view/driver.cxx
+++ b/view/driver.cxx
@@ -36,14 +36,7 @@ main (int argc, char* argv[])
 #ifndef DATABASE_ORACLE
           db->execute ("DROP TABLE view_employee_extra");
 #else
-          db->execute ("BEGIN "
-                       "  EXECUTE IMMEDIATE "
-                       "    'DROP TABLE \"view_employee_extra\" "
-                       "       CASCADE CONSTRAINTS';"
-                       "  EXCEPTION "
-                       "    WHEN OTHERS THEN "
-                       "      IF SQLCODE != -942 THEN RAISE; END IF;"
-                       "END;");
+          db->execute ("DROP TABLE \"view_employee_extra\"");
 #endif
           t.commit ();
         }
-- 
cgit v1.1