Is that Possible To create package Overloading , If Yes Give any Examples
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;
/
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what are the prerequisites for costing transactions?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
Plz anybody send me Technical specification for AP Interface
what is the difference between request group and request security in oracle apps?
Can you explain the difference between architecture followed in 10g & 11g?
What are the Standard Reports and Forms in HRMS?
Is soa a part of oracle fusion middleware?
In support project one ticket alloted which steps follows manualy tell me ?
is it possible to run the interface without using oracle apps?
What is sca and how is it useful?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What are the different components of soa suite?
what are the balancing segments in AR?
Explain oracle apps architecture.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?