根据最大版本执行语句

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_INFO set FOMR_SCRIPT = '
controlButton(''transmitDiv,setProcessButton,fileUploadsButton'');
'
where PROCESSDEFINE_NAME = 'XMB7' and PROCESSDEFIN_ = ids;

COMMIT;
END;
/