When the procedures or packagess become invalidate
- 3 Answers
- 7547 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is different between inline query,subquery& corelated query?
What is Virtual Memory?
please explain about oracle
What is supporting issues GL AP and AR?
What is index? How many types of indexes?
what are basic modules required to implement oracle application in any oraganisation?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
Name two files used for network connection to a database.
What command would you use to encrypt a PL/SQL application?
Explain materialized views and how they are used.
Could you please let me know the interfaces in OM / FA??
why r u using etl tool.
Oracle General 
