maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_preference_set()
Parameters
Name
Type
Mode
idclient
integer
OUT
Definition
/* 20151113 RRB To complete missing preferences from customer accounts */ DECLARE r record; _idpreference INTEGER; BEGIN FOR r IN SELECT c.idclient FROM client c WHERE c.idpreference is null LOOP INSERT INTO preference (idpreference,createbyuser,lastmodifiedbyuser,lastmodificationdate,originatingsystem) SELECT nextval('sec_preference'),0,0,now(),'DBA' RETURNING idpreference INTO _idpreference; UPDATE client c SET idpreference = _idpreference WHERE c.idclient = r.idclient; END LOOP; END;