If you have to declare procedure1,procedure2 in package
specification and if you have to declare
procedure1,procedure2 and procedure3 in package body? is it
compilation or not and execute or not? what type of error
is given please



If you have to declare procedure1,procedure2 in package specification and if you have to declare ..

Answer / rajesh venati

No, error will occur, because you declared procedure1 and
procedure2 in specification, those are must and should be
define in the package body, other wise it raise an error.

We can declare any no of procedures in body, with out
declared in specification, those are accessible only local.

Is This Answer Correct ?    10 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the use of sql trace?

0 Answers  


Write a unique difference between a function and a stored procedure.

0 Answers  


what is called after appearing where clause

3 Answers  


Can we call stored procedure in function?

0 Answers  


Can we join two tables without common column?

0 Answers  






What is basic structure of pl sql?

0 Answers  


What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,


What are the different types of tables in sql?

0 Answers  


What is prepared statement in sql?

0 Answers  


What is oracle and pl sql?

0 Answers  


what is a view? : Sql dba

0 Answers  


What is pl/sql and what is it used for?

4 Answers  


Categories