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

Question

question

OraLearner asked Jan 11, '10

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

My scenario is that I want to use the same named 2 functions with the same type of input parameters. Will it be possibile to have this with different return types ? Thank you.

oracle parameters function

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-01-17T03:36:23Z

KillerDBA answered Jan 17, '10

No. To overload a function, you must change the "signature" of the function, which is the defined by the position and datatype of the inputs. The return value is not part of the signature, so it can't be used for overloading.

"Oracle Database 11g PL/SQL Programming," by Michael McLaughlin, page 318

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-01-12T12:34:51Z

OraLearner answered Jan 12, '10

The answer is NO. Since we cannot overload the functions based on its return types.

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question