Home » SQL & PL/SQL » SQL & PL/SQL » procedures,functions becoming invalid
procedures,functions becoming invalid [message #37780] Thu, 28 February 2002 00:48 Go to next message
umesh
Messages: 23
Registered: March 2000
Junior Member
hi,
Somebody ,please help.
I have many procedures and functions refer single object(table /view). i donot change the definition of the objects ever.(I am using oracle 8.0.3 on NT)
Only data manipulation is done.Even then,I found many procedures,functions become invalid.
Why so? any Solution?
thanx in advance

umesh
Re: procedures,functions becoming invalid [message #37789 is a reply to message #37780] Thu, 28 February 2002 04:52 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
are u dropping and recreating the index ? it may create problem in 8.0.3 due to some bug.
Previous Topic: Trusted Oracle
Next Topic: Storing Image's..
Goto Forum:
  


Current Time: Fri Mar 29 02:55:29 CDT 2024