Answer Posted / 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

What is execution plan in sql?

1052

---

What is a pdo connection?

1045

---

Can we commit inside a trigger?

998

---

What is delimiter in pl sql?

1064

---

What is a unique key?

1056

---

What are pl/sql cursors?

1056

---

define join and explain different type of joins? : Sql dba

954

---

what is a trigger? : Sql dba

1033

---

what happens if you no create privilege in a database? : Sql dba

1002

---

Explain the difference between rename and alias?

1015

---

what is the difference between truncate and delete statement? : Transact sql

1067

---

What is sql constant?

1039

---

What is a delimiter in sas?

1059

---

Can you have more than one trigger on a table?

1003

---

Why use truncate instead of delete?

1017

---