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: oracle dba <aoracledba_at_gmail.com>
Date: 11 Jan 2007 02:22:55 -0800
Message-ID: <1168510975.277845.88370@k58g2000hse.googlegroups.com> 






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



run this command :



alter function < function_name > compile;
show error



it will show you the error.
Received on Thu Jan 11 2007 - 04:22:55 CST












Original text of this message













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