Answer Posted / ranjith
If a stored procedure(Function or Procedure) need to be
called inside another stored procedure in the same package
then the called procedure should be declared before the
calling procedure. This declartion is called Forward
Reference.
Example:
CREATE OR REPLACE PACKAGE BODY pkg_FR_Test
.
.
Begin
prc_FR_Procedure(p_P1 NUMBER, p_P2 VARCHAR2);--> FR
.
.
prc_Call_Procedure(p_Param1 NUMBER)
BEGIN
.
.
prc_FR_Procedure(20, 'Account');
.
.
END prc_FR_Procedure;
END
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what are the balancing segments in AR?
what is the differences between internal requisition and internal sales order?
Tell me how to find the custom directory in front end?
What is oracle soa suite?
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
In oracle application how do you debug or trace errors?
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
List the types of flexfield?
what is the difference between request group and request security in oracle apps?
How to move the one file from one instance to another instance? And your scripts also?
how can i print random rows in plsql table
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What are the benefits of using soa architecture?
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 is sca and how is it useful?
