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 global tempory table?

7146

---

What do you understand by a set of books?

1057

---

In oracle application how do you debug or trace errors?

1065

---

What are file in oracle.

2189

---

Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2329

---

Explain what are the tables of auto invoice?

1100

---

In hierarchical structure of a database? we have write query from where we should start?

2194

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2174

---

How can you achieve loose coupling in soa framework?

1184

---

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

1070

---

Can u give the Documentation of Custom.pll in oracle apps

3435

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2179

---

Is soa a part of oracle fusion middleware?

1050

---

What are the different components of soa suite?

1152

---

is it possible to run the interface without using oracle apps?

1941

---