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 / 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 |
Post New Answer View All Answers
What is count(*) from po_vendors(any table)?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
What do you understand by soa and what are the benefits of using this architecture?
What are the different components of soa suite?
What is oracle soa suite and what are its different components?
Do you know what are user profiles in apps. Any examples you can give?
can we use look up type instead of a pofile option?or valueset?is it possible how?
tell my any difficult situtation you solved in your experience in your company?
how to print multi lay outs,muti currency,muti language in xml publisher
What are the Standard Reports and Forms in HRMS?
What does appl_top directory contain?
In support project one ticket alloted which steps follows manualy tell me ?
List the types of flexfield?
What is sca and how is it useful?
List the various types of value set.