36: num_delcascadehint := 0;
37: num_suplog := 0;
38:
39: select decode (count(*), 0, 0, 1) into num_capture
40: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE';
41:
42: select decode (count(*), 0, 0, 1) into num_ds_capture
43: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE' and
44: UPPER(capture_type) = 'DOWNSTREAM';
39: select decode (count(*), 0, 0, 1) into num_capture
40: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE';
41:
42: select decode (count(*), 0, 0, 1) into num_ds_capture
43: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE' and
44: UPPER(capture_type) = 'DOWNSTREAM';
45:
46: select decode (count(*), 0, 0, 1) into num_apply from dba_apply
47: where UPPER(purpose) IN ('GOLDENGATE APPLY', 'GOLDENGATE CAPTURE');