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 an invalid partition table?

1026

What is db journal file?

1070

What is benefit of creating memory optimized table?

974

What is clustered and nonclustered index in sql?

944

How to use distinct and count in sql query? Explain

1026

What is multiple columns?

1071

what is the difference between truncate and delete statement? : Transact sql

1066

what does it mean to have quoted_identifier on? : Sql dba

1146

What is the difference between sql and mysql?

1122

What is set serveroutput on in pl sql?

1301

In what condition is it good to disable a trigger?

1013

What is %type in pl sql?

972

what are null values? : Sql dba

959

How to avoid using cursors?

1126

What are the different dcl commands in sql?

1176