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 |
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is dense_rank?
What is mdb stand for?
What is trigger types of trigger?
package specification-3 procedures package body-2 procedures will is execute
What is the current version of sql?
What do you mean by dbms? What are its different types?
What is materialised View?
what are the join types in tsql? : Transact sql
how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900
What is fmtonly in sql?
What is a temporal data type?