When the procedures or packagess become invalidate
- 3 Answers
- 6907 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 |
Differentiate between transaction type and transaction source? : oracle accounts receivable
What view would you use to determine free space in a tablespace?
Explain the payment term in ar. : oracle accounts receivable
What do you mean by Oracle MEDIA RECOVERY?
what is domain in database and its benefits?
Describe what redo logs are.
types of receipts and detail desription about recipts and tables effected by receipts?
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Where would you look for errors from the database engine?
Oracle General 
