Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\patches\fix2963565.sql
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; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de