I have a package in which a table was used in a procedure and compiled later i

I have a package in which a table was used in a procedure
and compiled later i have dropped the table used in the
package what would be the status of package specification
and body

Question Posted / guntu

1 Answers
6532 Views
TCS, I also Faced
E-Mail Answers

I have a package in which a table was used in a procedure and compiled later i have dropped the ta..

Answer / dhiraj

Package specification remain valid package body will become
invalid

Is This Answer Correct ?

21 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

how to delete an existing column in a table? : Sql dba

0 Answers

What is null in pl/sql?

0 Answers

How do you get all records from 2 tables. Which join do you use?

8 Answers Microsoft,

What is pl/sql table? Why is it used?

0 Answers

What are the limitations of sql express?

0 Answers

What is loop in pl sql?

0 Answers

What is materialized view in sql?

0 Answers

How do I truncate a word?

0 Answers

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers Satyam,

How does stored procedure reduce network traffic?

0 Answers

Can a commit statement be executed as part of a trigger?

0 Answers

For more SQL PLSQL Interview Questions Click Here