Re: ORA-06575: Package or function VALUE_1 is in an invalid state
From: Odd Morten Sve?s <odd.morten.sveas_at_accenture.com>
Date: 10 May 2004 13:03:12 -0700
Message-ID: <4306a83.0405101203.7e40c17a_at_posting.google.com>
Date: 10 May 2004 13:03:12 -0700
Message-ID: <4306a83.0405101203.7e40c17a_at_posting.google.com>
> 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 - 22:03:12 CEST