RE: Invalid Objects but no errors

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Fri, 15 Nov 2002 10:32:39 -0800
Message-ID: <F001.0050492B.20021115103239@fatcity.com>

I had some issues on an import lately with replication packages. I have recently gone from 8.1.7.3 to .4 and some of the packages would not compile. The solution was to run repcatr.sql, repcat.sql and utlrp.sql.

-----Original Message-----
Sent: Friday, November 15, 2002 12:10 PM To: Multiple recipients of list ORACLE-L

try

SHOW ERRORS PACKAGE BODY DBMS_REPCAT_RGT show errors may be showing there are no errors in the package spec!

Kevin

-----Original Message-----
Sent: Friday, November 15, 2002 12:40 PM To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Toepke, Kevin M
  INET: ktoepke_at_trilegiant.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

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 - 12:32:39 CST