By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

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

P: n/a
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 :-)
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jul 19 '05 #2

P: n/a
> 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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.