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 the autonomous transaction?give me example?

2 Answers   Cap Gemini,

---

Define MultiOrg Structure

5 Answers   Convergys,

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---

What is oracle soa suite and what are its different components?

0 Answers  

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

0 Answers  

---

PL/SQL stored procedure parameters?

7 Answers  

---

What is multoorg and what is it's level or structure

4 Answers   IBM,

---

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

---

How to send the e-mail notification in XML Pub Report?

2 Answers   Accenture, Oracle,

---

how can we return morethan one parameters in procedure?

2 Answers  

---

what is unit of measure classes? give atleast two examples. name the underlying table.

1 Answers   Scan Steel,

---

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

---