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> drop type employee_myError;
Type dropped.
SQL>
SQL> drop type dynsql_myError;
Type dropped.
SQL>
SQL> drop type myError;
Type dropped.
SQL>