When the procedures or packagess become invalidate

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

please send me oracle pl/sql exp resume. and also faqs...

2044


Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1251


My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

1754


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1709


Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

669






HOW TO SPOT AHIERARCHY?

1855


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3354


How do you create a credit note against an invoice? : oracle accounts receivable

659


Explain prerequisites and post activities of oracle database installation

1622


What is chargeback invoice? How do we create it? : oracle accounts receivable

734


What is the importance of batch source set up in ar? : oracle accounts receivable

725


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

1557


types of receipts and detail desription about recipts and tables effected by receipts?

1642


Difference between transaction type and transaction sources. : oracle accounts receivable

585


how to replace not in with not exist?

3199