Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 r the type Models in the system parameters of the report?

1 Answers  


What is Summary columns?

1 Answers  


what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,


What are the Standard Reports and Forms in HRMS?

0 Answers  


please send me forms, xml pulisher questions,answers

0 Answers   Zensar,


explain p2p cycle? what are the tables used for this?

3 Answers   Accenture,


A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

0 Answers   Accenture,


How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,


how to call report from oracle oracle apps11i?

3 Answers   Genpact,


Name the different Cursor Attributes.

2 Answers   Satyam,


What is P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,


How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  


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)