DBEU Phase II

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

Print Friendly, PDF & Email

About wendlerb

I didn't drown.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *