maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_tmp_badcalamp()
Parameters
Name
Type
Mode
Definition
/* to fix and log the setting of calamp devices with wrong idmodeldevice*/ BEGIN IF NEW.serialnumber like '000004%' OR NEW.serialnumber like '4%' THEN NEW.serialnumber := ltrim(NEW.serialnumber,'0'); IF NEW.idmodeldevice = 1 THEN NEW.idmodeldevice := 4; END IF; END IF; RETURN NEW; EXCEPTION WHEN OTHERS THEN RAISE WARNING '% , % ',SQLSTATE,SQLERRM; RETURN NEW; END;