Answer / siddharth

Package overloading: Packages can contain multiple iterations of procedures with the same name using different parameters. This is called 'overloading'.
Package overloading is possible in Oracle.

Example:
Identify An Overloaded PACKAGE

SELECT overload, position, argument_name, in_out, data_type
FROM all_arguments
ORDER BY overload, position;


CREATE OR REPLACE PACKAGE overload_pkgIS
PROCEDURE insby(namein VARCHAR2);
PROCEDURE insby(numbin PLS_INTEGER);
END overload_pkg;
/

q)what are the validations in sql*loader

0 Answers   Accenture,

---

AOL?

4 Answers  

---

what is MRC? Why it is needed?

4 Answers   Convergys,

---

Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,

---

Plz anybody send me Technical specification for AP Interface

0 Answers   Satyam,

---

What is an Index , Types od index why we are use index.

2 Answers   IBM,

---

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

---

how to make a parameter optional in the query?

2 Answers   Wipro,

---

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

4 Answers   Covansys,

---

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

What r the type Models in the system parameters of the report?

1 Answers  

---

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

2 Answers   Accenture,

---