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|
what is the difference b/w oracle8i and oracle9i
What are the mandatory setups in setting up a PO in oracle
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Name three advisory statistics you can collect.
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
Name two files used for network connection to a database.
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
How do you use trigger to create mutating state of table
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.