Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 1,386 of 2,288    |
|    Frank van Bortel to srihari    |
|    Re: ORA-06575: Package or function VALUE    |
|    10 May 04 19:02:27    |
      From: fvanbortel@netscape.net              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              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca