Oracle-L: Re: Invalid Objects but no errors

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Fri, 15 Nov 2002 11:48:46 -0800
Message-ID: <F001.00504A64.20021115114846@fatcity.com>

Is something dropped from that database relating to that package body?

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Fri, 15 Nov 2002 09:40:22 -0800

I checked for invalid objects and two of them came up. When I tried to recompile them it says there was compilation errors. Yet "show errors" doesn't show anything. Does anyone have familiarity with this particular package or have an idea on how to fix this so it is valid?

SYS                            DBMS_REPCAT_RGT                PACKAGE BODY

SVRMGR> alter package dbms_repcat_rgt compile body; MGR-00072: Warning: PACKAGE DBMS_REPCAT_RGT created with compilation errors. SVRMGR> show errors
No errors for PACKAGE DBMS_REPCAT_RGT

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric Richmon
   INET: cemail2_at_sprintmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* 
http://join.msn.com/?page=features/virus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: M Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Fri Nov 15 2002 - 13:48:46 CST