Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Errors for PACKAGE BODY DBMS_SQLPA - 10.2.0.4

edited Nov 11, 2017 4:04AM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered

Hi,

I try upgrade from 10.2.0.4 to 10.2.0.5.

I have one package in invalid status: SYS.DBMS_SQLPA

Errors for PACKAGE BODY DBMS_SQLPA:

LINE/COL ERROR

-------- -----------------------------------------------------------------

265/5    PL/SQL: Statement ignored

265/27   PLS-00302: component 'I_VALIDATE_PROCESS_ACTION' must be declared

I try to ran this procedure:

SQL>sqlplus / as sysdba

SQL>drop table plan_table;

SQL>@?/rdbms/admin/utlxplan

SQL>@?/rdbms/admin/prvtspao.plb

SQL>@?/rdbms/admin/utlrp.sql

but the package is still in invalid status.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center