日期:2014-05-16  浏览次数:20412 次

根据最大版本执行语句
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;
/