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
- 12488 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 |
Hoe to skip middle of the record by using SQL*Loader?
in which tables the transaction details stored? at least two.
In sequence i want to 11 and 15th values how we will write?
Plz anybody send me Technical specification for AP Interface
we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?
While running the concurrent program we will get the status, we have to change the status. How it will be done.
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
in procedure how to return a value
How to print invoice from APPS(front end).if we have invoice number in hand with us???
Can function be overload?
What is the package?
What are the Standard Reports and Forms in HRMS?
Oracle Apps Technical 
