When the procedures or packagess become invalidate

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain prerequisites and post activities of oracle database installation

1621


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

1798


What is db_recovery_file_dest in oracle? When do you need to set this value?

655


What do you mean by Oracle MEDIA RECOVERY?

731


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

731






How many segment are present in Oracle Manufacturing

1813


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1911


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

1245


which one is currently in used software cmpanies.

1663


how to write customizations in po

1203


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

734


1. What is PO rate variance gain and loss?

2318


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

1913


What is an Oracle database Partial Backup?

702


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

1736