When the referenced object's signature is changed the procedure get

when a procedure /package is getting invalidated?

Question Posted / p.rajasekar

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

Please Help Members By Posting Answers For Below Questions

Is id a reserved word in sql?

648

Is sql microsoft?

537

What is the use of double ampersand (&&) in sql queries? Give an example

596

how to drop an existing index in mysql? : Sql dba

527

How can we link a sql database to an existing android app?

538

What is dml and ddl?

511

What is data type in database?

531

what is a trigger? : Sql dba

565

What is the use of stored procedures?

506

what is sql server agent? : Sql dba

595

What is the purpose of the sql select top clause?

538

Is primary key always clustered index?

528

How do you take the union of two tables in sql?

509

What does the base_object_type column shows in the user.triggers data dictionary view?

562

Does mysql support pl sql?

613