Is that Possible To create package Overloading , If Yes Give any Examples
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;
/
| Is This Answer Correct ? | 5 Yes | 2 No |
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
What are the tables in GL?
what are the balancing segments in AR?
we have 10 records. It's occured error in 6th record how can u find and how to rectify that?
What is SRW Package? (Sql Report Writer)
what type of testing u r doing?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake
what is item status? name the related table.
Can we create tables in apps schema?
Can u give the Documentation of Custom.pll in oracle apps