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 ?
- 7 Answers
- 12957 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhuapps
Yes the Package body will be compiled.
The end result is you have a package with 3 Public
procedures and 1 Private Procedure.
You cannot call the 4th procedure as it is a Private
Procedure available within the Package only
| Is This Answer Correct ? | 29 Yes | 1 No |
Answer / apps
Yes, Madhu Is Right.
It will be compiled but you can not use that 4th procedure
out of that package body.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / 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 |
Answer / nishant srivastava
package will get compliled and three procedure will be
accessible from package while the fourth one can only be
access with package body
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / srinivas
package will be executed.
when u want to call a private procedure defined in the
package body,u need to cal the procedure first in the
procedure(one of them).
| Is This Answer Correct ? | 1 Yes | 1 No |
what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?
what is the purpose of standard cost update?
What are the files you have used in the part of Conversion and Interfaces?
where do u specify in org_id?
how many groups we can create for query?
Cycle of requestion to receving transaction.
can we use look up type instead of a pofile option?or valueset?is it possible how?
In report we have to show two Layout? how it is and how we can see from where it?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
difference between 2 way and 4 way matching
How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?
2 Answers Deloitte, Intelligroup,
what is the defference between credit memo and debit memo
Oracle Apps Technical 
