home bbs files messages ]

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