Is that Possible To create package Overloading , If Yes Give any Examples



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

Post New Answer

More Oracle Apps Technical Interview Questions

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,


How You Will display the key flexifields in your report

3 Answers   TCS,


what is the need of registering table in apps?

5 Answers   TCS,


what is difference between po_headers_all and po_headers

2 Answers   NTT Data,


what are the sql attributes?

2 Answers  






what is mean by confine mode and flexi mode?

2 Answers  


how will u do documentation

2 Answers  


Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers  


how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers   Amdocs,


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.

1 Answers   BirlaSoft,


What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,


Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)