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.

while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,

---

HOW CAN U KNOW TABLE IS REGISTERD IN APPS?

3 Answers  

---

What do you understand by soa and what are the benefits of using this architecture?

0 Answers  

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

0 Answers   Cap Gemini,

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,

---

what is the use of placeholer column?

3 Answers  

---

difference b/w procedures&functions

2 Answers   Oracle, TCS,

---

diff between key and descriptive flexfield.

4 Answers   Convergys,

---

what are the error tables in OM

2 Answers   Fujitsu,

---

What is workflow?Explain with a example?

2 Answers   Oracle,

---

why r u transer the data base tables to flat file and what is use

3 Answers   Wipro,

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---