create or replace procedure bug2963565 is 
boundname VARCHAR2(255); 
begin 
  for cursor in (select elementid , bounddata from 
cmpprocessactivityparameter_v where owner in (select elementid from 
cmpsubprocess_v)) 
  loop 
    BEGIN 
    select cpa.name into boundname from cmpprocessactivityparameter_v
cpa 
where cpa.elementid = cursor.bounddata; 
    update cmpprocessactivityparameter_v set note = (boundname || '^' ||

'null' || '^' || 'null') where elementid = cursor.elementid; 
    EXCEPTION when NO_DATA_FOUND then 
      null; 
    END; 
  end loop; 
end bug2963565; 
/ 

declare 
begin 
  bug2963565; 
  commit; 
end; 
/