maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_commandexec_setstatusto4(character varying, integer)
Parameters
Name
Type
Mode
in_serialnumber
character varying
IN
current_status
integer
IN
Definition
begin IF in_serialnumber in (SELECT serialnumber FROM tmp.testdevices) or in_serialnumber in (SELECT serialnumber FROM tmp.noresequence) THEN update commandexec set status=4, enabled = false where iddevice=(select iddevice from device where serialnumber=in_serialnumber) and status= current_status; END IF; return true; end;