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

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to know the reason for invalid function

Re: Is it possible to know the reason for invalid function

From: Oradba Linux <oradba_linux_at_verizon.net>
Date: Thu, 11 Jan 2007 10:23:39 GMT
Message-ID: <Leoph.17374$rz3.3458@trnddc03> 





Raghav wrote:


> Hi,

> 

> Is it possible to figure out the reason due to which a function is

> invalid at any point in time ?

> 

> Kindly help.

> 

> regards

> raghav..

> 



yes. check out user_dependencies. If any of the dependent objects 
changes then the function will become invalid and needs to be recompiled.
Received on Thu Jan 11 2007 - 04:23:39 CST












Original text of this message













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