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 the different ways to optimize a sql query?

0 Answers  

Is subquery faster than join?

0 Answers  

what is the main difference between join and subqurey?

3 Answers   Oracle,

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

cursor types? explain with example programs?

1 Answers   HP,

Is the primary key an index?

0 Answers  

What does joining a thread mean?

0 Answers  

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

Can we use distinct and group by together?

0 Answers  

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

How to use distinct and count in sql query? Explain

0 Answers  

What are advantages of Stored Procedures?

3 Answers   Satyam,