SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Package Body Dropped, but showing Invalid

AquaNX4Jul 15 2014 — edited Jul 16 2014

Good Day:

Oracle 11gR2

I've created a Package with Package Body as 3 Procedures that works fine. I can call it without any errors. However, if I run this query:

SELECT *
  FROM user_objects
  WHERE status = 'INVALID'

I get the following output:

OBJECT_NAME

SUBOBJECT_NAME

OBJECT_ID

DATA_OBJECT_ID

OBJECT_TYPE

CREATED

LAST_DDL_TIME

TIMESTAMP

STATUS

TEMPORARY

GENERATED

SECONDARY

NAMESPACE

EDITION_NAME

TASK_PROCEDURES

28700

PACKAGE BODY

5-Jul-14

11-Jul-14

2014-07-11:18:42:39

INVALID

This is an old package body I dropped approx. 4 days ago. Is that still supposed to show if I run this query?

This post has been answered by Sven W. on Jul 15 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2014

Added on Jul 15 2014

10 comments

710 views