Can 2 functions have same name & input parameters but
differ only by return datatype ?
Answers were Sorted based on User's Feedback
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 |
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 |
How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
in procedure how to return a value
What is an Index , Types od index why we are use index.
What is REF Cursor?
19 Answers Infosys, Intelligroup,
HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?
what are the tables of auto invoice.
How to register a form and stored procedure in oracle apps
Hoe to skip middle of the record by using SQL*Loader?
how to call report from oracle oracle apps11i?
what is the back ground program run while transferring data from OM to AR?
in ap_terms table what data will be stored
How to call oracle database stored procedure from form in form coding ?