Oracle PL/SQL Tutorial/Object Oriented/FINAL

NOT FINAL

   <source lang="sql">

SQL> CREATE TYPE myError AS OBJECT (

 2     name VARCHAR2(100),
 3     code INTEGER,
 4     description VARCHAR2(4000),
 5     help_text VARCHAR2(4000),
 6     recommendation VARCHAR2(4000),
 7     error_stack CLOB,
 8     call_stack CLOB,
 9     created_on DATE,
10     created_by VARCHAR2(100)
11     )
12     NOT FINAL
13     ;
14  /

Type created. SQL> SQL> CREATE TYPE dynsql_myError UNDER myError (

 2     sql_string CLOB
 3     )
 4     NOT FINAL
 5     ;
 6  /

Type created. SQL> SQL> CREATE TYPE employee_myError UNDER myError (

 2     employee_id INTEGER,
 3     rule_id INTEGER
 4     )
 5     ;
 6  /

Type created. SQL> SQL> SQL> drop type employee_myError; Type dropped. SQL> SQL> drop type dynsql_myError; Type dropped. SQL> SQL> drop type myError; Type dropped. SQL> SQL> SQL></source>