Interested to Buy Any Domain ? << Click Here >> for more details...
When the procedures or packagess become invalidate
- 3 Answers
- 8410 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 |
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
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 auto invoicing? Explain : oracle accounts receivable
What is Virtual Memory?
A scenario for amount correction & how to use amount correction functionality in AP invoices
what is debit memo and credit memo in AR?
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
What is autocashrule set? : oracle accounts receivable
what is the difference between oracle 81,91,11i
what are basic modules required to implement oracle application in any oraganisation?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
How do you use trigger to create mutating state of table
Oracle General 
