Here is what is on the DBEU FAQ for Phase II:
Phase Two will be executed as part of the installation of the Banner XE applications such as Catalog, Schedule, Faculty Grade Entry etc. This phase of the Database Extension Utility will ”enable” 2 of the columns added in Phase 1 (SURROGATE_ID and VERSION) and will only do this for tables that are associated with the Banner XE application being installed. Enabling the columns will consist of populating each column with a default value and updating each column to be NOT NULL. Triggers to populate these columns will also be added at this phase.
I was able to create a junk table with two not null columns temp1 and temp2.
I then created the following trigger:
CREATE OR REPLACE TRIGGER ft_junk
BEFORE INSERT ON JUNK
FOR EACH ROW
BEGIN
IF :NEW.temp2 IS NULL THEN
:NEW.temp2 := ‘test2’;
END IF;
END;
Then the following worked:
B8TST> insert into junk (temp1) values (‘test’);
1 row created.
B8TST> select * from junk;
TEMP1 TEMP2
———- ———-
test test2
