stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_DOCUMENT_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_DOCUMENT_H" AFTER INSERT OR UPDATE OR DELETE ON DOCUMENT REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.DOCUMENT_H (DOCUMENT_ID,NAME, EXTENSION,DESCRIPTION,CONTENT_TYPE,BINARY,VERSION_ID,CUSER,CDATE,MUSER,MDATE,action) VALUES(:late.DOCUMENT_ID, :late.NAME, :late.EXTENSION, :late.DESCRIPTION, :late.CONTENT_TYPE, :late.BINARY, :late.VERSION_ID, :late.CUSER, :late.CDATE, :late.MUSER, :late.MDATE, action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.DOCUMENT_H (DOCUMENT_ID,NAME, EXTENSION,DESCRIPTION,CONTENT_TYPE,BINARY,VERSION_ID,CUSER,CDATE,MUSER,MDATE,action) VALUES(:late.DOCUMENT_ID, :late.NAME, :late.EXTENSION, :late.DESCRIPTION, :late.CONTENT_TYPE, :late.BINARY, :late.VERSION_ID, :late.CUSER, :late.CDATE, :late.MUSER, :late.MDATE, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.DOCUMENT_H (DOCUMENT_ID,NAME, EXTENSION,DESCRIPTION,CONTENT_TYPE,BINARY,VERSION_ID,CUSER,CDATE,MUSER,MDATE,action) VALUES(:late.DOCUMENT_ID, :late.NAME, :late.EXTENSION, :late.DESCRIPTION, :late.CONTENT_TYPE, :late.BINARY, :late.VERSION_ID, :late.CUSER, :late.CDATE, :late.MUSER, :late.MDATE, action); END IF; END;