SP_DELETE_JOB_QUEUE Store Proc Invalid While Running 6.2.1.1067 DB Scripts (Doc ID 2228111.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Goal

 While running 6.2.1.1067 Db Scripts we found that it has rendered the following store procedure invalid.
SP_DELETE_JOB_QUEUE.

Manual compilation of the stored proc resulted in the following errors.

[1]:(Error): PL/SQL: ORA-01031: insufficient privileges
[2]:(Error): PL/SQL: SQL Statement ignored
[3]:(Error): PL/SQL: ORA-01031: insufficient privileges
[4]:(Error): PL/SQL: SQL Statement ignored

On these lines:
DELETE FROM job.report_detail
WHERE job_id = del_jobs_record.job_id;

DELETE FROM job.report_header
WHERE job_id = del_jobs_record.job_id;

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms