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;
/

What are profile options?

4 Answers   Accenture,

---

HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers  

---

What is the package?

2 Answers  

---

what is organization id

2 Answers   Wipro,

---

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,

---

---

what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .

3 Answers   Infosys, Oracle,

---

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

3 Answers   Wipro,

---

Tell me where we find the status of order information?

0 Answers  

---

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  

---

please explain open interface import

2 Answers  

---

What is the difference between base table and multi-org table?

3 Answers   Infosys,

---

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,

---