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.
|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|
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
Give the reasoning behind using an index.
wht r the base tables & primary key for BOM& WIP modules
how to replace not in with not exist?
How do you create a credit note against an invoice? : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
Explain the difference between a hot backup and a cold backup and the benefits associated with each
what is sql*loader parameters and where we will use it.
Where in the Oracle directory tree structure are audit traces placed?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
How would you determine who has added a row to a table?