can we write multiple procedures in package with same name
like A p1,p2(parameters)
B p1,p2(same parameters)
- 4 Answers
- 13421 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 |
Steps for DFF registration
What are the different components of soa suite?
What are different execution methods of executabls?
testing tools?
0 Answers BirlaSoft, Convergys,
PL/SQL stored procedure parameters?
what is the standard program for blanket po to process data from interface table to bace table
Who information?s?
how will u do documentation
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.
10 Answers HCL, TCS,
where the accounting related data is stored ?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
Oracle Apps Technical 
