Answer / mukesh rathi

Package is a named anonymus block.
It is collection of varible, procedure,function.
There is need of package specification and body and there
name should be same for creating package.
We can also declare global,local procedure function within
the package.
Due to the use of package the performace improved because
it directly interact with the memory location avilable to
the package.

Answer / kiran kumar

---- Group logically related pl/sql types, items and
subprograms.
1) package specification
2) package body
Advantages of a package:

? Modularity
? Easier Application Design
? Information Hiding
? Overloading

what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,

---

What are the Major differences between appcore.pll and appcore2.pll

5 Answers   Infosys, Sierra Atlantica,

---

in one report using two layout models.if yes how to do

4 Answers   Covansys,

---

while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  

---

What are the different components of soa suite?

0 Answers  

---

what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,

---

While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,

---

HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers   TCS,

---

what is flexfield qualifier?

3 Answers  

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---

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,

---

What is procedure?

3 Answers   IBM,

---