overloading of stored procedure is possible in oracle?
Answers were Sorted based on User's Feedback
Answer / neeraj siddhey
Overloading: Multiple subprograms of the same name
• Enables you to use the same name for different
subprograms inside a PL/SQL block, a subprogram, or a
package
• Requires the formal parameters of the subprograms to
differ in number, order, or data type family
• Enables you to build more flexibility because a user or
application is not restricted by the specific data type or
number of formal parameters
Note: Only local or packaged subprograms can be overloaded.
You cannot overload stand-alone subprograms.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / monika
No, Only packaged procedures and procedures exists in
pl/sql blocks can be overloaded.Stored procedures can't.
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / vipin kumar
This is how its works
create or replace package vips_test as
function addition(a1 in number, b in number, c1 in number default 0) return number;
function addition(a1 in number, b in number ,d1 in number default 0) return number;
end;
/
show errors;
create or replace package body vips_test as
function addition(a1 in number, b in number, c1 in number default 0)
return number is
begin
dbms_output.put_line('---------------1----------------------');
return a1+b+c1;
end;
function addition(a1 in number, b in number ,d1 in number default 0)
return number is
begin
dbms_output.put_line('---------------2----------------------');
return a1+b+d1;
end;
end;
/
show errors;
select vips_test.addition(a1 => 1 ,b =>2, c1 => 2) from dual;
but if you will try calling as above
select vips_test.addition(a1 => 1 ,b =>2) from dual;
SQL Error: ORA-06553: PLS-307: too many declarations of 'ADDITION' match this call
06553. 00000 - "PLS-%s: %s"
Is This Answer Correct ? | 3 Yes | 3 No |
What are the two characteristics of a primary key?
how to calculate the difference between two dates? : Sql dba
Is ms sql traffic encrypted?
What is the importance of sqlcode and sqlerrm?
What is sql performance tuning?
what is 'mysqlcheck'? : Sql dba
how to include character strings in sql statements? : Sql dba
what are date and time intervals? : Sql dba
Is sql developer case sensitive?
How many levels can subqueries be nested in a FROM clause?
What is the Difference between Procedure and Function.Can we call a Function in a DML?
What is pl sql record in oracle?