From e8a334106c3a330dfb202a538338d4aad547c3e3 Mon Sep 17 00:00:00 2001 From: Boris Kolpackov 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