When the procedures or packagess become invalidate

Answers were Sorted based on User's Feedback

When the procedures or packagess become invalidate..

Answer / guest

procedures or packagess can become invalid
if it using some object which is in invalid state.


Is This Answer Correct ?    2 Yes 1 No

When the procedures or packagess become invalidate..

Answer / pavan

most of the packages or procedure become invalid after a
upgrade.example when u upgrade the server and database from
8i to 9i.So beore upgrading its neccesary to make a list of
already invalid procedures and packages, so that wont have
problems after upgrading and to find new p & p's which
became invalid after upgrading.

Is This Answer Correct ?    1 Yes 1 No

When the procedures or packagess become invalidate..

Answer / sonu

In any way, if the system is altered like by migration,
change in system date, import or export, upgrade the
system, then procedures or packages become invalidate or,
if a dependant object has been altered, it will invalidate
the stored procedure. This includes stored procedures,
packages, tables, types, etc.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle AllOther Interview Questions


4 Answers  

Give the reasoning behind using an index.

2 Answers  

wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,

how to replace not in with not exist?

0 Answers   IBM,

How do you create a credit note against an invoice? : oracle accounts receivable

0 Answers  

What is the importance of batch source set up in ar? : oracle accounts receivable

0 Answers  

Explain the difference between a hot backup and a cold backup and the benefits associated with each

1 Answers  

what is sql*loader parameters and where we will use it.

1 Answers   Accenture,

Where in the Oracle directory tree structure are audit traces placed?

0 Answers  

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

0 Answers  

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

How would you determine who has added a row to a table?

0 Answers  

  • Oracle General Interview Questions Oracle General (1003)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (0)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (484)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (0)
  • Oracle RAC Interview Questions Oracle RAC (20)
  • Oracle D2K Interview Questions Oracle D2K (53)
  • Oracle AllOther Interview Questions Oracle AllOther (241)