diff options
| author | Constantin Michael <constantin@codesynthesis.com> | 2011-11-18 11:38:21 +0200 |
|---|---|---|
| committer | Constantin Michael <constantin@codesynthesis.com> | 2011-11-18 11:38:21 +0200 |
| commit | 42cdbf617c6d0ef178266f5a3be2431c4f399dc4 (patch) | |
| tree | eadcde8c7000225ca55f46f846795a142a4921af /view | |
| parent | 58bde6bf60f6a87d5bba4d8bd21156335cef2bc6 (diff) | |
Simplify drop table SQL for Oracle
Diffstat (limited to 'view')
| -rw-r--r-- | view/driver.cxx | 9 |
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 (); } |