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

where the accounting related data is stored ?

2 Answers  

---

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

---

what is mean by confine mode and flexi mode?

2 Answers  

---

Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?

3 Answers   Oracle,

---

can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,

---

name at least five reports in oracle inventory related to transaction ?

3 Answers   Scan Steel,

---

Explain the multi-organization structure.

1 Answers   Accenture,

---

What repots or concurrent program run to transfer data from Inventory to GL.

5 Answers   IBM, iGate,

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---

How many standard interface programs in oracle purchasing module and oracle inventory? What are they?

3 Answers   KPIT,

---

what is the database size you used?

1 Answers   FIS,

---

Give a overview on Aol

2 Answers   Zensar,

---