diff options
Diffstat (limited to 'oracle/custom/custom.sql')
-rw-r--r-- | oracle/custom/custom.sql | 21 |
1 files changed, 1 insertions, 20 deletions
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; |