Re: ORA-06575: Package or function VALUE_1 is in an invalid state

> SQL> desc value_1;
> ERROR:
> ORA-24372: invalid object for describe
if you do
select status from dba_objects where object_name = 'VALUE_1';

you get the status of your function.

To see the what errors you are getting i suggest you logg into sql plus and run you function declaration there. Afterwards you just issue the command:
show errors;
and any compilation errors are displayed.

There migth bee som functionality for this in pro*c as well, but I do not know that tool any good.

regards
Odd m Received on Mon May 10 2004 - 15:03:12 CDT