when a procedure /package is getting invalidated?
Answers were Sorted based on User's Feedback
Answer / rao
When table is droped with out drop the objects
(package/procedure/function/view)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / p.rajasekar
When the referenced object's signature is changed the
procedure get invalidated or the referenced object is
changed or droped
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rao
When table is droped with out drop the objects
(package/procedure/function/view)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajesh
while the user don't have the sufficient privilege to
execute the procedure/package.or else while the owner of
the procedure/package alters the name of the
procedure/package it becomes invalidated....
| Is This Answer Correct ? | 0 Yes | 2 No |
What is data control language?
What is composite primary key in sql?
What is right join sql?
What is a call statement? Explain with an example.
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
What is a .db file?
Are stored procedures compiled?
What is procedure and function?
What are the different operators available in sql?
when is the use of update_statistics command? : Sql dba
What are the key differences between SQL and PL SQL?
How do I audit the sql sent to the server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)