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 is responsibility and how u attach

5 Answers   Accenture,

---

How to develop XML report without rdf?

4 Answers   Oracle,

---

Hi Experts How to Create a purchase order without a requisition ?

6 Answers   Amdocs, KPMG, Oracle,

---

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

---

what is inbound and outbound interface?

2 Answers  

---

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

3 Answers   Satyam,

---

Tell me how to find the custom directory in front end?

0 Answers  

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

what is back order in OM

4 Answers   IBM, Oracle,

---

testing tools?

0 Answers   BirlaSoft, Convergys,

---

what is the difference between request group and request security group in oracle apps?

2 Answers   BirlaSoft,

---

What is SRW Package? (Sql Report Writer)

1 Answers  

---