Can 2 functions have same name & input parameters but differ only by retur

Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical
Suggest New Category

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

Question Posted / kiran kumar da

5 Answers
12586 Views
I also Faced
E-Mail Answers

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