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

how view used for security purposes?

3 Answers   Glam India,

how to write date and time literals? : Sql dba

0 Answers  

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

What is mutating sql table?

0 Answers  

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

What is a design view?

0 Answers  

How can triggers be used for the table auditing?

0 Answers  

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

What is a table in a database?

0 Answers  

What does “select count(1) from tab” result?

10 Answers   IBM,

define sql delete statement ? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories