Solved

Object sys.DBMS_SQLPA package is invalid.

Posted on 2014-02-21
2
598 Views
Last Modified: 2014-04-22
Hi,

  The current object is invalid.  

   SYS      DBMS_SQLPA      PACKAGE BODY      INVALID


  What is the procedure to make it invalid ?, i been searching the internet and i have found the below procedure to fix it.


drop table plan_table
@?/rdbms/admin/utlxplan.sql
@?/rdbms/admin/prvtspao.plb
@?/rdbms/admin/utlrp.sql


select OWNER,object_name,object_type from dba_objects where object_name='PLAN_TABLE';

SYS      PLAN_TABLE      TABLE
PUBLIC      PLAN_TABLE      SYNONYM
SYSTEM      PLAN_TABLE      TABLE


What would be the table to be dropped ?

Is that the correct way to fix this error ?

Regards,
0
Comment
Question by:joe_echavarria
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39877907
Have you manually tried to recompile it?  Objects become invalid all the time.

A manual recompile should also allow you to see the errors generated if it fails to recompile.

>>Is that the correct way to fix this error ?

@?/rdbms/admin/utlrp.sql will recompile all objects in dependency order so I would first start with this.

It can take a while to run so be patient.

>>What would be the table to be dropped ?

What table?
0
 
LVL 1

Author Comment

by:joe_echavarria
ID: 40015134
I just needed to recompile it.  Is not invalid now.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question