Interested to Buy Any Domain ? << Click Here >> for more details...
When the procedures or packagess become invalidate
- 3 Answers
- 8711 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 |
How many segment are present in Oracle Manufacturing
how to replace not in with not exist?
what is the difference b/w oracle8i and oracle9i
How can you rebuild an index?
how can it possibble to see the report output in excel sheet in oracle applications
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What Are Cross Validation & Adi?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
What are different types of transactions in ar? : oracle accounts receivable
Name three advisory statistics you can collect.
where the dff data will be stored
Oracle General 
