Oracle PL/SQL Tutorial/Object Oriented/FINAL

NOT FINAL

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>