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 to insert data into two tables using single control file?

3 Answers   Oracle, VTI,

---

what is pick selection list generation report.

3 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  

---

what is meant by boilerplates?

1 Answers  

---

where do u specify in org_id?

2 Answers  

---

---

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,

---

tell me the scenarios of between pages in reports

5 Answers  

---

How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,

---

Form development process?

1 Answers  

---

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

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

---

Plz anybody send me Technical specification for AP Interface

0 Answers   Satyam,

---

When loading data from staging table to interface table , how to reload the invalid record once again ?

6 Answers   Accenture,

---