From 3801402911f59a5a375fb0d0fda29edb4b7dd9c0 Mon Sep 17 00:00:00 2001 From: Constantin Michael Date: Thu, 6 Oct 2011 12:11:44 +0200 Subject: Compact Oracle drop_table PL/SQL code --- odb/relational/oracle/schema.cxx | 14 ++++---------- 1 file changed, 4 insertions(+), 10 deletions(-) (limited to 'odb') 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; } -- cgit v1.1