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 workflow?Explain with a example?

2 Answers   Oracle,

---

Tell me some interface tables on ordermangement.

1 Answers   Zensar,

---

What are the validations you don in .CTL file in inbound interface process?

1 Answers  

---

After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?

3 Answers   IBM,

---

diff between key and descriptive flexfield.

4 Answers   Convergys,

---

---

what is repeting frame?

3 Answers   TCS,

---

What is the difference between buyer&employee in PO module?

7 Answers   TCS,

---

What are profile options?

4 Answers   Accenture,

---

what is the difference between varchar and varchar(2)?

4 Answers  

---

tell me the scenarios of between pages in reports

1 Answers   TCS, Wipro,

---

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,

---

Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen

2 Answers   TCS,

---