When the procedures or packagess become invalidate

Question Posted / pravin

3 Answers
8599 Views
TCS, I also Faced
E-Mail Answers

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.

Pravin

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 index? How many types of indexes?

2 Answers HCL,

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

0 Answers HP,

What command would you use to create a backup control file?

1 Answers

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers HCL,

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

0 Answers

What is the difference between recovery and restoring of the oracle database?

0 Answers

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers TCS,

What is the Symbol use for Inner Join

1 Answers Oracle, TCS,

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

4 Answers Icon,

how to display last 5 letters from a name (take emp table ename )

6 Answers IBM,

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers

For more Oracle AllOther Interview Questions Click Here