Interested to Buy Any Domain ? << Click Here >> for more details...
When the procedures or packagess become invalidate
- 3 Answers
- 8461 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 |
what is the difference between oracle 81,91,11i
How client makes connection with server in client/server architecture?
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
Give the stages of instance startup to a usable state where normal users may access it.
Why more redos are generated when the oracle database is in begin backup mode?
WHAT IS CARTESIAN PRODUCT?
Whats the purpose of using Nextval while creating the sequence.
deference between & and &&
what is the link between suppliers and banks in ap module in oracle apps? And also query?
What is the use of lockboxes? : oracle accounts receivable
Oracle General 
