Answer / vpl

No.
for overloading, parameters must differ by type family--
whereas CHAR, VARCHAR and VARCHAR2 belongs to same family.

Answer / vpl

No.
for overloading, parameters must differ by type family--
whereas CHAR, VARCHAR and VARCHAR2 belongs to same family.

This will actually allow you to create the pack but will
give run time error.

Answer / bunty

Yes. you can create package where overloading will be
identified by using type of arguments.

Following code will work fine,
--WORK's FINE

create or replace package PK_TEST AS

procedure p1(a IN varchar);
procedure p1(a IN varchar2);
procedure p1(a IN char);

end PK_TEST;

But,following code will not work as p1( v1 IN varchar) and
p1(v3 IN varchar) has the same type of arguments.

--NOT WORK
create or replace package PK_TEST AS

procedure p1(v1 IN varchar);
procedure p1(v2 IN varchar2);
procedure p1(v3 IN varchar);

end PK_TEST;

Cheers,
Bunty

Answer / sudhakar naraparaju

I created a test package and executed.

create or replace package test is
procedure p1(v1 in Varchar);
Procedure p2(v2 in varchar2);
procedure p3(v3 in char);
end;
/

create or replace package body test is
procedure p1(v1 in Varchar) is

begin
dbms_output.put_line(' The input data for v1 is: '||v1);
end;

Procedure p2(v2 in varchar2) is

begin
dbms_output.put_line(' The input data for v2 is: '||v2);
end;

procedure p3(v3 in char) is
begin
dbms_output.put_line(' The input data for v3 is: '||v3);
end;

end;
/

I called each procedure in sql by setting the serveroutput
on:

begin
test.P3('Testing Procedure P3');
end;

I got the below output:
The input data for v1 is: Testing Procedure P1
The input data for v2 is: Testing Procedure P2
The input data for v3 is: Testing Procedure P3

Answer / sudhakar naraparaju

I created a test package and executed.

create or replace package test is
procedure p1(v1 in Varchar);
Procedure p2(v2 in varchar2);
procedure p3(v3 in char);
end;
/

create or replace package body test is
procedure p1(v1 in Varchar) is

begin
dbms_output.put_line(' The input data for v1 is: '||v1);
end;

Procedure p2(v2 in varchar2) is

begin
dbms_output.put_line(' The input data for v2 is: '||v2);
end;

procedure p3(v3 in char) is
begin
dbms_output.put_line(' The input data for v3 is: '||v3);
end;

end;
/

I called each procedure in sql by setting the serveroutput
on:

begin
test.P3('Testing Procedure P3');
end;

I got the below output:
The input data for v1 is: Testing Procedure P1
The input data for v2 is: Testing Procedure P2
The input data for v3 is: Testing Procedure P3

What are types of joins?

0 Answers  

How to find string or key value using pl/sql code?

2 Answers   Ramco,

What is compound trigger?

0 Answers  

How do you optimize a stored procedure query?

0 Answers  

Where the Pre_defined_exceptions are stored ?

2 Answers  

Is sql better than access?

0 Answers  

Which one is better sql or oracle?

0 Answers  

What is procedure in pl sql?

0 Answers  

Why do we go for stored procedures?

0 Answers  

How does index help in query performance?

0 Answers  

What steps server process has to take to execute an update statement?

0 Answers  

Why is sql*loader direct path so fast?

0 Answers