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.

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

0 Answers  

---

Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.

3 Answers  

---

what are the different types of parameters avialable in reports?

2 Answers   Oracle,

---

Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen

2 Answers   TCS,

---

What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,

---

---

What is request group

4 Answers   Accenture,

---

What is REF Cursor?

19 Answers   Infosys, Intelligroup,

---

what are the important table names in purchasing?

3 Answers   TCS,

---

What is responsibility and how u attach

5 Answers   Accenture,

---

Give a overview on Aol

2 Answers   Zensar,

---

What is cursor?

3 Answers  

---

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

25 Answers   IBM, Satyam,

---