When the procedures or packagess become invalidate
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 the difference between recovery and restoring of the oracle database?
What view would you use to determine free space in a tablespace?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Explain about party and customer in ar : oracle accounts receivable
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
pl help me, i want oracle HRMS training institute address,in chennai
what is the link between suppliers and banks in ap module in oracle apps? And also query?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Explain the process of recievables in oracle financials. : oracle accounts receivable
Explain an ORA-01555
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
Give the reasoning behind using an index.