exception.ot

来自「OReilly Oracle PL SQL Programming第4版源代码」· OT 代码 · 共 31 行

CREATE TYPE exception_t AS OBJECT (
   name VARCHAR2(100),
   code INTEGER,
   description VARCHAR2(4000),
   help_text VARCHAR2(4000),
   recommendation VARCHAR2(4000),
   error_stack CLOB,
   call_stack CLOB,
   created_on DATE,
   created_by VARCHAR2(100)
   )
   NOT FINAL
   ;
/

CREATE TYPE dynsql_exception_t UNDER exception_t (
   sql_string CLOB
   )
   NOT FINAL
   ;
/

CREATE TYPE employee_exception_t UNDER exception_t (
   employee_id INTEGER,
   rule_id INTEGER
   )
   ;
/