oracle streams changng DISABLE_ON_ERROR parameter

[PaulH]

Can anybody tell me the query I can run through sqlplus in order to do
the workaround described below.

Thanks


The workaround for that is go and open enterprise manager and connect to each db and double click apply name under Streams and under parameter tab change value "DISABLE_ON_ERROR" from Y to N.

[PAVB]

BEGIN
  DBMS_APPLY_ADM.SET_PARAMETER(
    apply_name  => 'apply_stream', 
    parameter   => 'disable_on_error', 
    value       => 'n');
END;
/