Answer / 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

Answer / raghav

PL/SQL does not allow forward references. You must declare a variable or constant before referencing it in other statements, including other declarative statements.

Answer / ranjith

The above answer is for "Forward Declaration" and not
for "Forward Reference".

Sorry for the confusion.

Answer / veera

declaring the procedures or functions in the package
specification before using them in package body.

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

0 Answers  

---

Can u suggest me the best institute for Oracle apps Technical in Hyderabad?

16 Answers  

---

How to register a form and stored procedure in oracle apps

2 Answers   Mastek, TCS,

---

what u did after ur btech(2009) till now? why did u prefer oracle apps technical?

1 Answers   Intelligroup,

---

What is REF Cursor?

19 Answers   Infosys, Intelligroup,

---

how to initialize applications?

2 Answers  

---

Plz anybody send me Technical specification for AP Interface

0 Answers   Satyam,

---

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

---

what are the pl/sql tables

1 Answers   IBM,

---

What is the difference between BPA AND Contract.

1 Answers   Accenture,

---

I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,

---

what is lexical parameter?

3 Answers   TCS,

---