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

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

SQL> ALTER FUNCTION <function_name> COMPILE;

Warning: Function altered with compilation errors.

SQL> SHOW ERRORS or

SQL> SELECT * FROM USER_ERRORS; HTH -g Received on Thu Jan 11 2007 - 04:27:27 CST