aboutsummaryrefslogtreecommitdiff
path: root/view/driver.cxx
diff options
context:
space:
mode:
authorConstantin Michael <constantin@codesynthesis.com>2011-11-18 11:38:21 +0200
committerConstantin Michael <constantin@codesynthesis.com>2011-11-18 11:38:21 +0200
commit42cdbf617c6d0ef178266f5a3be2431c4f399dc4 (patch)
treeeadcde8c7000225ca55f46f846795a142a4921af /view/driver.cxx
parent58bde6bf60f6a87d5bba4d8bd21156335cef2bc6 (diff)
Simplify drop table SQL for Oracle
Diffstat (limited to 'view/driver.cxx')
-rw-r--r--view/driver.cxx9
1 files changed, 1 insertions, 8 deletions
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 ();
}