when a procedure /package is getting invalidated?

Answer Posted / p.rajasekar

When the referenced object's signature is changed the
procedure get invalidated or the referenced object is
changed or droped

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain two easy sql optimizations.

777


What does select top 1 do in sql?

737


What is sqlcontext?

727


Can I join the same table twice?

758


How many types of literals are available in pl sql?

765


How do I run a sql trace?

700


How does stored procedure reduce network traffic?

745


How do you identify a primary key?

827


How to make a copy values from one column to another in sql?

779


What is the command used to fetch first 5 characters of the string?

1111


What is natural join in sql?

720


How to select 10 records from a table?

862


What are the advantages of pl sql over sql?

747


What is the use of & in pl sql?

740


What is pivot table in sql?

758