Re: Invalid Objects but no errors

2002-11-15 Thread M Rafiq
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 recom

RE: Invalid Objects but no errors

2002-11-15 Thread Post, Ethan
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 r

RE: Invalid Objects but no errors

2002-11-15 Thread Toepke, Kevin M
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 t

Re: Invalid Objects but no errors

2002-11-15 Thread Paul Baumgartel
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 s

Invalid Objects but no errors

2002-11-15 Thread Eric Richmond
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