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.

how can we return morethan one parameters in procedure?

2 Answers  

---

What is request group

4 Answers   Accenture,

---

What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,

---

What are file in oracle.

0 Answers   BirlaSoft, IBM,

---

where the accounting related data is stored ?

2 Answers  

---

what is aim methodolozy

1 Answers  

---

API?s FOR CUSTOMER INTERFACE? Tell me some API's?

1 Answers  

---

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,

---

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

7 Answers   Accenture,

---

How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  

---

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers   CTS, iGate,

---

Is SOB is attached with Business grp ?

2 Answers   Convergys,

---