Answer Posted / palaniraman balasubramanian

Special sub program unit declaration called forward
declaration, Consider below the example

In this pacakage, the first program unit is calling the
calc_rating but calc_rating is defined last in the package;
if we are not declared the fwd declaration then it will
raise the error While compiling this package. Package
compilation always happens top to bottom. For resolving
this compilation issue, you should declare the fwd
declaration.

CREATE OR REPLACE PACKAGE BODY forward_pack
IS
PROCEDURE calc_rating(. . .); -- forward
declaration
PROCEDURE award_bonus(. . .)
IS -- subprograms
defined
BEGIN -- in alphabetical
order
calc_rating(. . .);
. . .
END;

PROCEDURE calc_rating(. . .)
IS
BEGIN
. . .
END;

END forward_pack;

In support project one ticket alloted which steps follows manualy tell me ?

2611

---

where to define interorganization transaction charges and what are the different options?

2370

---

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

2003

---

tell me the scenarios of the independent in reports

2564

---

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

1065

---

what is global tempory table?

7126

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2211

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2043

---

how can i print random rows in plsql table

2415

---

List the types of flexfield?

990

---

Explain what are the tables of auto invoice?

1096

---

What do you understand by a set of books?

1043

---

What are do's and dont's of Interface?

2369

---

What are the different components of soa suite?

1146

---

In hierarchical structure of a database? we have write query from where we should start?

2172

---