SET serveroutput ON
declare
status1 boolean;
begin
status1 := cdr_profiles_pkg.SAVE
('DMW:Set Based Processing Enabled','$YESNO$NO','SITE');
if status1 then
dbms_output.put_line('Success');
else
dbms_output.put_line('Failure');
end if;
end;
/
commit;
Make sure that executing the following query returns the result as
$YESNO$NO:
select cdr_profiles_pkg.value('DMW:Set Based Processing
Enabled') from dual;
If the result of the query is not $YESNO$NO,
contact Life Sciences Support.