From e8a334106c3a330dfb202a538338d4aad547c3e3 Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Thu, 13 Sep 2012 12:02:43 +0200
Subject: Use new --sql-interlude option to fix Oracle custom test

---
 oracle/custom/custom.sql | 21 +--------------------
 1 file changed, 1 insertion(+), 20 deletions(-)

(limited to 'oracle/custom/custom.sql')

diff --git a/oracle/custom/custom.sql b/oracle/custom/custom.sql
index 94ff5f5..191f397 100644
--- a/oracle/custom/custom.sql
+++ b/oracle/custom/custom.sql
@@ -1,24 +1,7 @@
 /* This file contains custom type definitions and helper functions.
  */
 
-SET FEEDBACK OFF;
-WHENEVER SQLERROR EXIT FAILURE;
-WHENEVER OSERROR EXIT FAILURE;
-
--- @@ Temporary workaround: we cannot replace a type if there are
---    tables that use it. So need to drop the tables first, then
---    create/replace the type, and then create the tables.
---
---CREATE OR REPLACE TYPE Numbers AS VARRAY(100) OF NUMBER(10);
-
-BEGIN
-  BEGIN
-    EXECUTE IMMEDIATE 'CREATE TYPE Numbers AS VARRAY(100) OF NUMBER(10)';
-  EXCEPTION
-    WHEN OTHERS THEN
-      IF SQLCODE != -955 THEN RAISE; END IF;
-  END;
-END;
+CREATE OR REPLACE TYPE Numbers AS VARRAY(100) OF NUMBER(10);
 /
 
 CREATE OR REPLACE FUNCTION string_to_numbers(in_str IN VARCHAR2) RETURN Numbers
@@ -57,5 +40,3 @@ BEGIN
   RETURN ret;
 END;
 /
-
-EXIT;
-- 
cgit v1.1

