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

Is soa a part of oracle fusion middleware?

597


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1674


Can we create tables in apps schema?

604


How do you register report in oracle apps?

612


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

641






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

632


how can i print random rows in plsql table

1913


what are the balancing segments in AR?

1638


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

1504


List the types of flexfield?

590


what is pay run id ?

1693


What are do's and dont's of Interface?

1890


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2577


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

1633


What is a value set? List its various types.

636