Interested to Buy Any Domain ? << Click Here >> for more details...
When the procedures or packagess become invalidate
- 3 Answers
- 8449 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 |
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is supporting issues GL AP and AR?
What command would you use to encrypt a PL/SQL application?
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
What is an Oracle database Partial Backup?
How would you determine who has added a row to a table?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How would you determine the time zone under which a database was operating?
What is the Query Optimizer. How you optimize your qeury.
what is correlated subquery
Oracle General 
