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 are the Import Programs We need to run after creating Interface table for all modules
How You Will display the key flexifields in your report
what is the need of registering table in apps?
what is difference between po_headers_all and po_headers
what are the sql attributes?
what is mean by confine mode and flexi mode?
how will u do documentation
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.
What is profile and what is level of profile option and it's hierarchy
Except the SRS window in which we can submit the concurrent program.