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 is Value Set?

2 Answers   Accenture,

---

Tell me some interface tables on ordermangement.

1 Answers   Zensar,

---

FLEX FIELDS?

2 Answers  

---

Exception Handilings?

1 Answers  

---

What is secuirity's in R12 features.

1 Answers   KPIT,

---

---

define steps of assigning items to an organization.

1 Answers   Scan Steel,

---

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,

---

what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

0 Answers   Cap Gemini,

---

What is oracle soa suite?

0 Answers  

---

we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?

1 Answers  

---