diff options
| author | Constantin Michael <constantin@codesynthesis.com> | 2011-10-06 12:11:44 +0200 |
|---|---|---|
| committer | Constantin Michael <constantin@codesynthesis.com> | 2011-10-21 11:47:12 +0200 |
| commit | 3801402911f59a5a375fb0d0fda29edb4b7dd9c0 (patch) | |
| tree | 95bff709f1c996463af77c5af4801bf9c7df1fc7 /odb/relational/oracle/schema.cxx | |
| parent | e24285488fc771a62bb92b34bf0304f46975b1b7 (diff) | |
Compact Oracle drop_table PL/SQL code
Diffstat (limited to 'odb/relational/oracle/schema.cxx')
| -rw-r--r-- | odb/relational/oracle/schema.cxx | 14 |
1 files changed, 4 insertions, 10 deletions
diff --git a/odb/relational/oracle/schema.cxx b/odb/relational/oracle/schema.cxx index db0b882..5504927 100644 --- a/odb/relational/oracle/schema.cxx +++ b/odb/relational/oracle/schema.cxx @@ -35,26 +35,20 @@ namespace relational "';" << endl << " EXCEPTION" << endl << " WHEN OTHERS THEN" << endl - << " IF SQLCODE != -942 THEN" << endl - << " RAISE;" << endl - << " END IF;" << endl + << " IF SQLCODE != -942 THEN RAISE; END IF;" << endl << " END;" << " BEGIN" << endl << " EXECUTE IMMEDIATE 'DROP SEQUENCE " << quote_id (table + "_seq") << "';" << endl << " EXCEPTION" << endl << " WHEN OTHERS THEN" << endl - << " IF SQLCODE != -2289 THEN" << endl - << " RAISE;" << endl - << " END IF;" << endl + << " IF SQLCODE != -2289 THEN RAISE; END IF;" << endl << " END;" << endl << " EXECUTE IMMEDIATE 'DROP TRIGGER " << - quote_id (table + "_auto_id_trig") << "';" << endl + quote_id (table + "_trig") << "';" << endl << " EXCEPTION" << endl << " WHEN OTHERS THEN" << endl - << " IF SQLCODE != -4080 THEN" << endl - << " RAISE;" << endl - << " END IF;" << endl + << " IF SQLCODE != -4080 THEN RAISE; END IF;" << endl << " END;" << endl << "END;" << endl; } |