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...

Assume i have three Procedures defined in a Package Spec.
I have created the Package Specification.
now i create the Package Body
by including the three procedures in addition to that i
include a fourth procedure which is not included in my
Package Spec.

I compile the Package Body.

Will the Package body Compile ?

What will the end result ?
what will happen if the execute the package by calling the
4th procedure ?

Answer Posted / ramanan

The Package will get compiled if and only the 4th procedure
is creaded before it is referenced in any of the other
procedures in the same package.

For example if my 4th procedure is referenced in 2nd
procedure and my 2nd is referenced in the 1st procedure so
on. it is better to have the 4th proceuder which is local
to that package in the first place. so that it does not
cause an issue.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is global tempory table?

7293


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2671


What are the different components of soa suite?

1265


List the types of flexfield?

1087


can we get profile values in report without using user exists is it possible how?

2933


How can a process be deployed in soa?

1333


how to print multi lay outs,muti currency,muti language in xml publisher

12394


how can i print random rows in plsql table

2571


Are you familiar with internet architecture of oracle apps 11i?

1128


Can you define an erp system?

1222


what is pay run id ?

2241


What is oracle soa suite and what are its different components?

1281


How do you register report in oracle apps?

1134


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2258


Tell me where we find the status of order information?

1194