1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / hanumanthareddy.u


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

Why should I use postgresql?

0 Answers  

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

What do we need to check in database testing?

0 Answers  

How will you distinguish a global variable with a local variable in pl/sql?

0 Answers  

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  




What normalization means?

0 Answers  

Why primary key is required?

0 Answers  

Which software is used for pl sql programming?

0 Answers  

Can we perform dml in function?

0 Answers  

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

What is the advantage of nosql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories