Answer Posted / 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 pay run id ?

1712

---

what are the prerequisites for costing transactions?

2636

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3086

---

what are the balancing segments in AR?

1657

---

What are file in oracle.

1816

---

---

What is instead of trigger in where we will use?

680

---

List the various types of value set.

627

---

Is soa a part of oracle fusion middleware?

611

---

how can i print random rows in plsql table

1944

---

What are the different components of soa suite?

728

---

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

666

---

Can you differentiate between mediator and osb?

629

---

In sequence i want to 11 and 15th values how we will write?

1577

---

What is a flexfield? List out its types.

669

---

Can we create tables in apps schema?

625

---