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
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What is oracle soa suite?
How to move the one file from one instance to another instance? And your scripts also?
what are the prerequisites for costing transactions?
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.
How can we import the data into a database using sql * loader?
Explain what are the tables of auto invoice?
How do you register report in oracle apps?
What are file in oracle.
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
tell my any difficult situtation you solved in your experience in your company?
Tell me how to find the custom directory in front end?
What do you understand by soa?