Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What are different functions in sql?

0 Answers  

How to disable a trigger name update_salary?

0 Answers  

Which is faster subquery or join?

0 Answers  

Can a table have no primary key?

0 Answers  

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

What is normalization sql?

0 Answers  

Explain the difference between drop and truncate commands in sql?

0 Answers  

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

What are sql built in functions?

0 Answers  

What is the use of function "module procedure" in pl/sql?

0 Answers  

Difference between views and materialized views?

5 Answers   BirlaSoft,

What is the difference between sql and isql*plus?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories