What is Overloading of procedures ?

Question Posted / swapna

4 Answers
11432 Views
Amdocs, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is Overloading of procedures ?..

Answer / madhuri

You can use the same name for different procedures if their
formal parameters differ in number, order, or data type family.

Is This Answer Correct ?

12 Yes

1 No

What is Overloading of procedures ?..

Answer / swapna

Overloading procs are 2 or more procs with the same name
but different arguments.

Is This Answer Correct ?

6 Yes

2 No

What is Overloading of procedures ?..

Answer / yalamanda

by using the same name we can write any no.of
procedures/functions in a package.but either no.of
parameters in the procedure/function must be varry or
parameter datatype must be varry

Is This Answer Correct ?

0 Yes

0 No

What is Overloading of procedures ?..

Answer / jyothsna

2 or more procedures or functions are called overloaded when

a) They have the same names
b) Different no of formal parameters defined
c) Formal parameters differ in their datatypes/Subtypes and
not in the same family
d) They belong to same subprogram/package/PL SQL Block

They are not overloaded when

a) Any of the above points are not satisfied
b) RETURN datatype alone differs and not the formal
parameters

The main purpose of overloading procedures is that, when a
PL SQL block is found to do a same operation with different
inputs, we names them same and feed different parameters

Is This Answer Correct ?

0 Yes

2 No

Post New Answer