maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_set_idunit()
Parameters
Name
Type
Mode
Definition
DECLARE BEGIN /* V20190307 RRB To provisionally populate the idunit field, until the MDW does it */ SELECT idunit INTO NEW.idunit FROM device WHERE iddevice = NEW.iddevice; RETURN NEW; EXCEPTION WHEN OTHERS THEN RAISE NOTICE '%,%', SQLSTATE, SQLERRM; RETURN NEW; END;