Home » RDBMS Server » Server Administration » Invalidated Stored Procedure
Invalidated Stored Procedure [message #60294] Fri, 30 January 2004 12:13 Go to next message
scott
Messages: 73
Registered: September 1999
Member
Hi,

Can someone write in detail what really happens and why a stored procedure is invalidated when the underlying base structure is changed.

Feel free to use Oracle jargon like (Library Cache, data Dictionary Cache) etc. I can follow it.

If someone has a good link please forward it

Thanks in advance

Scott

 

 

 

 

 

Report message to a moderator

Re: Invalidated Stored Procedure [message #60297 is a reply to message #60294] Fri, 30 January 2004 12:23 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Consider a procedure maintaining the sales information
is dependant on that table containing sales data.
If the table dropped or recreated or ALTER then
any references to the old table straucture and columns might become invalid.
Oracle does Automatic recompilation at the time of first call to the procedure .
Things will be fine if it compile without any error.

Satish Shrikhande
http://www.freewebs.com/oracledba/oracle.htm

Report message to a moderator

Previous Topic: Schedule to run job on the last date (monthly)
Next Topic: I can't start oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:38:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.