Interested to Buy Any Domain ? << Click Here >> for more details...
can we write multiple procedures in package with same name
like A p1,p2(parameters)
B p1,p2(same parameters)
- 4 Answers
- 14498 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
what is lexical parameter?
what is the difference between credit memo and debit memo?...
List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS
How can we import the data into a database using sql * loader?
can we use anchor propery in XML reports?if yes?explain?
When loading data from staging table to interface table , how to reload the invalid record once again ?
How to find which company will be conducted Oracle appa interview? Plz help me
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
What is workflow?Explain with a example?
API?s FOR CUSTOMER INTERFACE? Tell me some API's?
Oracle Apps Technical 
