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 ?

Answers were Sorted based on User's Feedback



Assume i have three Procedures defined in a Package Spec. I have created the Package Specification...

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

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification...

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

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification...

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

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification...

Answer / koti

Madhuapps Answer is Right.........

Is This Answer Correct ?    6 Yes 1 No

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification...

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

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification...

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

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification...

Answer / zakkam raju

it will not execute

Is This Answer Correct ?    3 Yes 15 No

Post New Answer

More Oracle Apps Technical Interview Questions

Define MultiOrg Structure

5 Answers   Convergys,


what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .

3 Answers   Infosys, Oracle,


what is user exit and wat program do we write in user exit?

4 Answers   iGate,


why r u transer the data base tables to flat file and what is use

2 Answers  


how can we get odd numbered pages in output of a report

2 Answers   Infosys,






where is setup of business group done?

2 Answers   TCS,


INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  


What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,


HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,


In what situation u create the BPA.

2 Answers   Accenture,


What are the validations you don in .CTL file in inbound interface process?

1 Answers  


what is repeting frame?

3 Answers   TCS,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)