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

Can 2 functions have same name & input parameters but differ only by return datatype ?

5 Answers  


How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,


hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,


How to migrate .rdf file from dev instance to test instance?

3 Answers   Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,


in ap_terms table what data will be stored

1 Answers  






what are the error tables in AP?

6 Answers  


explain o2c cycle? what are the table reflected for this process?

1 Answers   BirlaSoft,


how do you describe O2C along with tables

0 Answers   TCS,


In Per_all_people_f table what is the significance of '_f ' ?

6 Answers   HCL,


wht is difference between is and as varibales,while declaring procedure which is better?

3 Answers   Wipro,


How many phases of implementation and what are those.

2 Answers   Accenture,


How You Will display the key flexifields in your report

3 Answers   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)