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 use of format trigger?

4 Answers   Cap Gemini, IBM,

---

how to move the one file from one instance to another instance?and ur scripts also?

1 Answers   KPMG,

---

how to create a file in forms?

3 Answers   Wipro,

---

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

---

in procedure how to return a value

3 Answers  

---

is it possible to run the interface without using oracle apps?

0 Answers  

---

In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??

1 Answers  

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

WHAT IS USE OF APPS API?

3 Answers  

---

why we can use synonym?

6 Answers  

---

How many schemas we have? how many you have used?

0 Answers  

---