DBA Data[Home] [Help]

ORACLE_OCM.MGMT_CONFIG dependencies on DBMS_OUTPUT

Line 100: DBMS_OUTPUT.put_line('Do not raise an exception');

96: END IF;
97: EXCEPTION
98: WHEN OTHERS THEN
99: -- Don't raise an exception otherwise it fills the alert/trace
100: DBMS_OUTPUT.put_line('Do not raise an exception');
101: -- RAISE_APPLICATION_ERROR(-20000,'SQLERRM: ' || SQLERRM || ' SQLCODE: '|| SQLCODE);
102: END;
103:
104: -- create 2nd job if specified

Line 135: DBMS_OUTPUT.put_line('Do not raise an exception');

131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: -- Don't raise an exception otherwise it fills the alert/trace
135: DBMS_OUTPUT.put_line('Do not raise an exception');
136: END;
137: END IF;
138: END IF;
139: END IF;

Line 157: dbms_output.put_line('Configuration collection job name: ' || JOB_NAME);

153: Print the job details.
154: */
155: procedure print_job_details IS
156: BEGIN
157: dbms_output.put_line('Configuration collection job name: ' || JOB_NAME);
158: dbms_output.put_line('Statistics collection job name: ' || STATS_JOB_NAME);
159: dbms_output.put_line('Job Schedule: DAILY');
160: END print_job_details;
161:

Line 158: dbms_output.put_line('Statistics collection job name: ' || STATS_JOB_NAME);

154: */
155: procedure print_job_details IS
156: BEGIN
157: dbms_output.put_line('Configuration collection job name: ' || JOB_NAME);
158: dbms_output.put_line('Statistics collection job name: ' || STATS_JOB_NAME);
159: dbms_output.put_line('Job Schedule: DAILY');
160: END print_job_details;
161:
162: /*

Line 159: dbms_output.put_line('Job Schedule: DAILY');

155: procedure print_job_details IS
156: BEGIN
157: dbms_output.put_line('Configuration collection job name: ' || JOB_NAME);
158: dbms_output.put_line('Statistics collection job name: ' || STATS_JOB_NAME);
159: dbms_output.put_line('Job Schedule: DAILY');
160: END print_job_details;
161:
162: /*
163: Stop (and drop) the job.