can we write multiple procedures in package with same name
like A p1,p2(parameters)
B p1,p2(same parameters)

Answers were Sorted based on User's Feedback



can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(..

Answer / suresh

Yes this is what called "Procedure Overloading" Concept....

Might be all the given parameters be same, but the data
types will be different which produces different operations
as per defined in the procedure.

Is This Answer Correct ?    12 Yes 0 No

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(..

Answer / ranga reddy

Yes,This is called "Overloading"

We can use same names with different data types or
same names and same data types with different number of
parameters
(Ex:p1(3 parameters),p1(4 parameters))

Is This Answer Correct ?    6 Yes 2 No

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(..

Answer / devi nossam

yes,
we can write any number of procedures in one package
with the same name it is called as procedure overloading.
but those variables datatype must be different.

Is This Answer Correct ?    2 Yes 0 No

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(..

Answer / mahesh

in packages subprograms with same name
but the parameters are different data types
called 'SUBPROGRAM OVERLODING'

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Oracle Apps Technical Interview Questions

How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  


While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions

3 Answers   IBM,


What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  


I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,


what is the use of format trigger?a

3 Answers  






Give a brief overview on OrderManagement.

1 Answers   Zensar,


what is trace file? what is the use of that?

4 Answers  


how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  


What is ERP? Architecture of apps?

3 Answers   TCS,


in one report using two layout models.if yes how to do

3 Answers   Wipro,


Do you know where we can check the status of po?

0 Answers  


P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?

9 Answers   CSC, IBM, KPIT, Oracle,


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)