DROP TABLE SERVICE_EXCEPTIONS;


CREATE TABLE SERVICE_EXCEPTIONS
(

CORRELATION_ID VARCHAR2 (50) NOT NULL,
process_name   varchar2(100) not null,
INSTANCE_ID VARCHAR2 (50) NOT NULL,
ERROR_TIMESTAMP DATE DEFAULT SYSDATE NOT NULL,
ERROR_CATEGORY VARCHAR2 (50) NOT NULL,
ERROR_MESSAGE VARCHAR2 (2000),
INPUT_MESSAGE VARCHAR2 (2000),
STATUS_CODE NUMBER DEFAULT 0 ,
)
;

ALTER TABLE SERVICE_EXCEPTIONS
ADD CONSTRAINT SERVICE_EXCEPTIONS_PK1 PRIMARY KEY
(
process_name,
CORRELATION_ID,
INSTANCE_ID
)
 ENABLE
;
