overloading of stored procedure is possible in oracle?

Answers were Sorted based on User's Feedback



overloading of stored procedure is possible in oracle?..

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

overloading of stored procedure is possible in oracle?..

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

overloading of stored procedure is possible in oracle?..

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

Post New Answer

More SQL PLSQL Interview Questions

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  


What is dense_rank?

0 Answers  


What is mdb stand for?

0 Answers  


What is trigger types of trigger?

0 Answers  


package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,






What is the current version of sql?

0 Answers  


What do you mean by dbms? What are its different types?

0 Answers  


What is materialised View?

2 Answers   IBM,


what are the join types in tsql? : Transact sql

0 Answers  


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

8 Answers  


What is fmtonly in sql?

0 Answers  


What is a temporal data type?

0 Answers  


Categories