When the procedures or packagess become invalidate

Answers were Sorted based on User's Feedback

When the procedures or packagess become invalidate..

Answer / guest

procedures or packagess can become invalid
if it using some object which is in invalid state.


Is This Answer Correct ?    2 Yes 1 No

When the procedures or packagess become invalidate..

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

When the procedures or packagess become invalidate..

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

Post New Answer

More Oracle AllOther Interview Questions

what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,

What are the mandatory setups in setting up a PO in oracle

1 Answers   Silicon,

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

0 Answers   HCL,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

Name three advisory statistics you can collect.

1 Answers  

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,

Name two files used for network connection to a database.

1 Answers  

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers  


0 Answers  

How do you use trigger to create mutating state of table

2 Answers   TCS,

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

0 Answers   Accenture,