根据最大版本执行语句
SET DEFINE OFF;DECLARE
ids t_bpm_processdefine_info.processdefin_%TYPE;
num t_bpm_processdefine_info.processdefine_version%TYPE;
BEGIN
SELECT MAX (processdefine_version)
INTO num
FROM t_bpm_processdefine_info
WHERE processdefine_name = 'XMB7';
SELECT processdefin_
INTO ids
FROM t_bpm_processdefine_info
WHERE processdefine_name = 'GCJDJHBS330XB' AND processdefine_version = num;
update T_BPM_PROCESSDEFINE_INFOset FOMR_SCRIPT = '
controlButton(''transmitDiv,setProcessButton,fileUploadsButton'');
'
where PROCESSDEFINE_NAME = 'XMB7' and PROCESSDEFIN_ = ids;
COMMIT;
END;
/
页:
[1]