Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Procedure Invalid - Urgent

RE: Procedure Invalid - Urgent

From: Peter McLarty <Peter_McLarty_at_technologyonecorp.com>
Date: Thu, 12 Oct 2006 09:51:09 +1000
Message-ID: <1BFEF5A6856E7C4D89A3DEE609AF884BAEB4D7@brimail05.technologyonecorp.com>


Hi

Look for something dropping an object these use. I had an application that did a batch load and the developers had decided to drop a table as part of the clean up of the staging point before loading new data. It always invalidated the procedures that were called to load the data to its eventual location I had them alter the clean up to truncate of the staging tables

HTH Peter McLarty
Technical Consultant
Service Delivery
Technology One  



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: Thursday, 12 October 2006 9:16 AM
To: oracle-l_at_freelists.org
Subject: Procedure Invalid - Urgent

I have one application in production where several Procedure become invalid at the same time. Can somebody suggest as how I can check as why all become invalid. Currently I am running utlrp every 5 minutes so that application is not affected. This is the new aplication went live on the weekend,
TIA
Sanjay   



Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1/min.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 11 2006 - 18:51:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US