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
what is global tempory table?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What are the different components of soa suite?
List the types of flexfield?
can we get profile values in report without using user exists is it possible how?
How can a process be deployed in soa?
how to print multi lay outs,muti currency,muti language in xml publisher
how can i print random rows in plsql table
Are you familiar with internet architecture of oracle apps 11i?
Can you define an erp system?
what is pay run id ?
What is oracle soa suite and what are its different components?
How do you register report in oracle apps?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Tell me where we find the status of order information?