Yes, the total package body will become invalid and has to be recompiled

If a procedure within a package is invalidated whether the
entire package will be invalid and has to be recompiled
again?

Question Posted / guest

Answer Posted / guest

Yes, the total package body will become invalid and has to
be recompiled again

Is This Answer Correct ?

24 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a heap in sql?

991

how many tables will create when we create table, what are they? : Sql dba

1018

Why is theta join required?

1079

What is sql partition?

1035

What are sql data types?

948

what is 'trigger' in sql? : Sql dba

1011

Can a key be both primary and foreign?

943

What is the difference between inner join and natural join?

953

What does the acronym acid stand for in database management?

982

What is the use of prepared statement?

951

What is a mutating table and a constraining table?

1035

What are the advantages of stored procedure?

945

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1013

Explain the difference in execution of triggers and stored procedures?

966

When is the update_statistics command used?

1045