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

How do sql databases work?

527

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

662

What is on delete set null?

561

How to use transactions efficiently : transact sql

540

What is dense_rank?

534

What is the order of sql select?

572

How many sql statements are used? Define them.

573

Who is the owner of mysql database?

551

When is the explicit cursor used ?

588

how does a local variable is defined using t-sql? : Transact sql

539

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

525

Are views faster than queries?

538

How is sql used in oracle?

577

how would concatenate strings in mysql? : Sql dba

568

Can sql developer connect to db2?

582