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
- 10722 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What is sca and how is it useful?
Can u give the Documentation of Custom.pll in oracle apps
can we use look up type instead of a pofile option?or valueset?is it possible how?
Is soa a part of oracle fusion middleware?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How many schemas we have? how many you have used?
please send me forms, xml pulisher questions,answers
What are the Standard Reports and Forms in HRMS?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
What are the benefits of using soa architecture?
Tell me where we find the status of order information?
What do you understand by a set of books?
Which oracle apps version you are very confident in?
What are file in oracle.
