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

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

650


as a technical developer in oracle applications which type errors feced in your experience sofar

1777


How would you determine who has added a row to a table?

1798


what are the tools used for oracle 10g in real time.

1935


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1618






What is the disk migration? what is the steps involved in oracle disk migration?

723


default triggers available for reports

1761


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2364


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3994


I would like to study certification course in Data base adminidtrator then where would i go to study this course?

1731


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

1550


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

650


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

627


What is the difference between oracle media recovery and crash recovery?

680


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1625