In my experience, show errors is unreliable. Select from
dba/all/user_errors instead.
--- Eric Richmond [EMAIL PROTECTED] wrote:
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
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
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
Is something dropped from that database relating to that package body?
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 15 Nov 2002 09:40:22 -0800
I checked for invalid objects and two of them came up. When I tried to
