maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_commandexec_setstatus(character varying, integer, integer)
Parameters
Name
Type
Mode
in_serialnumber
character varying
IN
current_status
integer
IN
new_status
integer
IN
Definition
begin IF in_serialnumber in ('4832003683') THEN update message set messagestatus=new_status where iddevice=(select iddevice from device where serialnumber=in_serialnumber) and messagestatus= current_status; END IF; return true; end;