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

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,

---

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,

---

can u explain which situation automonus transaction is used

2 Answers  

---

what is the difference between oracle 8i and 9i?

1 Answers  

---

What is the reason for distribution hold. Why invoices will go on distribution variance hold ??

1 Answers   Oracle,

---

What is the autonomous transaction?give me example?

2 Answers   Cap Gemini,

---

How does accounting occured in Expense Reporting?

1 Answers   Sapient,

---

in one report using two layout models.if yes how to do

3 Answers   Wipro,

---

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

---

API?s FOR CUSTOMER INTERFACE? Tell me some API's?

1 Answers  

---

what is the need of registering table in apps?

5 Answers   TCS,

---

Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers   Wipro,

---