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

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

What are data types in pl sql?

0 Answers  

how to drop an existing table in mysql? : Sql dba

0 Answers  

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

how many tupples can insert in 1 second in sql

1 Answers  

What is difference between group by and partition by?

0 Answers  

what is a relationship and what are they? : Sql dba

0 Answers  

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

What is the use of stored procedures?

0 Answers  

What does the file extension accdb stand for?

0 Answers  

How many developers work on postgresql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories