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

Answers were Sorted based on User's Feedback



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

Answer / vasu

Yes, It is possible in the packages (packaged functions).
You can override the function. It works perfect.
But the same if you try on standalone this doesn't work.
Object must be unique.

Is This Answer Correct ?    8 Yes 2 No

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

Answer / kiran kumar

No.

Is This Answer Correct ?    4 Yes 0 No

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

Answer / matt mcpeak

You can create package with 2 functions that differ only by
return type, but anyone attempting to call the function
will get a PLS-00307 error (too many declarations of 'A'
match this call)

Is This Answer Correct ?    1 Yes 0 No

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

Answer / pr@$@d

Vasu Answer is perfect.

Is This Answer Correct ?    2 Yes 2 No

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

Answer / ginna

Yes. We can

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  


what is flexfield qualifier?

3 Answers  


what is the difference between credit memo and debit memo?...

2 Answers   Sony,


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,


what are the sql attributes?

2 Answers  






What is workflow?Explain with a example?

2 Answers   Oracle,


Can function be overload?

4 Answers  


How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,


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

3 Answers   Accenture,


where the accounting related data is stored ? all type of accounting related data costing etc...

3 Answers  


Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,


How does accounting occured in Expense Reporting?

1 Answers   Sapient,


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)