when a procedure /package is getting invalidated?

Answer Posted / rajesh

while the user don't have the sufficient privilege to
execute the procedure/package.or else while the owner of
the procedure/package alters the name of the
procedure/package it becomes invalidated....

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is mysql query is case sensitive? : Sql dba

775


Explain lock escalation? : Transact sql

867


How much does sql cost?

735


How can we find duplicate records in a table?

664


what is a table in a database ? : Sql dba

751






What is bind variable in pl sql?

723


What is loop in pl sql?

763


what are the type of locks ? : Sql dba

720


what are the difference between clustered and a non-clustered index? : Sql dba

731


How many types of cursors are available in pl/sql?

773


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

928


Why is there a need for sqlcode and sqlerrm variables?

756


Is natural join same as inner join?

683


Is pl sql different from sql?

717


How long it takes to learn pl sql?

724