when a procedure /package is getting invalidated?

Question Posted / sudhir

4 Answers
11915 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

when a procedure /package is getting invalidated? ..

Answer / rao

When table is droped with out drop the objects
(package/procedure/function/view)

Is This Answer Correct ?

3 Yes

0 No

when a procedure /package is getting invalidated? ..

Answer / 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

when a procedure /package is getting invalidated? ..

Answer / rao

When table is droped with out drop the objects
(package/procedure/function/view)

Is This Answer Correct ?

1 Yes

0 No

when a procedure /package is getting invalidated? ..

Answer / 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