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 can i print random rows in plsql table

1934


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

1684


What is the concept of soa governance?

766


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

1905


Can you define an erp system?

675






Can u give the Documentation of Custom.pll in oracle apps

2993


what is global tempory table?

6294


List the various types of value set.

620


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

646


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

633


What is instead of trigger in where we will use?

674


Are you familiar with internet architecture of oracle apps 11i?

629


Tell me how to find the custom directory in front end?

658


what is pay run id ?

1706


What do you understand by soa?

689