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.

Pravin

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

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

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  






Categories
  • 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)