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 oracle soa suite and what are its different components?
How many schemas we have? how many you have used?
what is the difference between request group and request security in oracle apps?
what are the prerequisites for costing transactions?
testing tools?
What do you understand by a set of books?
List the types of flexfield?
What are do's and dont's of Interface?
What do you understand by soa?
What is a value set? List its various types.
Are you familiar with internet architecture of oracle apps 11i?
In sequence i want to 11 and 15th values how we will write?
What are file in oracle.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What do you understand by concurrent programs?