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

[srihari]

Hi ,
I created a function in oracle using pro*C. I am not sure whether the
table got created properly. because when i try to see the description
it says,

SQL> desc value_1;
ERROR:
ORA-24372: invalid object for describe

also when i try to use the following query,

insert into table1 (select attrib,value_1(2) from table2)

i get the following error,

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

please tell me what could be the possible problem. where am i going
wrong.

thank you :-)

[Frank van Bortel]

srihari wrote:

Hi ,
I created a function in oracle using pro*C. I am not sure whether the
table got created properly. because when i try to see the description
it says,

SQL> desc value_1;
ERROR:
ORA-24372: invalid object for describe

also when i try to use the following query,

insert into table1 (select attrib,value_1(2) from table2)

i get the following error,

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

please tell me what could be the possible problem. where am i going
wrong.

thank you :-)

value_1 is NOT a table, but a function (at least - that's
what it should be). And it's invalid, as is the MDLVALUE_1 package
--

Regards,
Frank van Bortel

[Odd Morten Sve?s]

> 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