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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many schemas we have? how many you have used?

1628


How do you register report in oracle apps?

638


please send me forms, xml pulisher questions,answers

1667


Tell me how to debug the report?

655


Plz anybody send me Technical specification for AP Interface

2026






Can you explain the difference between architecture followed in 10g & 11g?

671


What are the benefits of using soa architecture?

718


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1659


What are the different components you should consider while defining a responsibility in oracle apps?

655


is it possible to run the interface without using oracle apps?

1524


Do you know what is applysys in oracle application database schema, what is apps?

685


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1767


can we get profile values in report without using user exists is it possible how?

2333


Do you know what are user profiles in apps. Any examples you can give?

669


How to move the one file from one instance to another instance? And your scripts also?

619