can use the following like overloading concept in a single
package:
procedure p1(a varchar),
procedure p1(a varchar2),
procedure p1(a char)
- 5 Answers
- 6965 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Can delete statement be rollbacked?
How would you reference column values before and after you have inserted and deleted triggers?
What is t-sql? : Transact sql
How do I restart sql?
What is the source code of a program?
What is the difference between a subquery and a join?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Explain mutating table error.
Explain ttitle and btitle.
Which are sql * plus commands?
Explain cursor types?
what is the difference between cluster and non cluster index? : Sql dba
Is sql microsoft?
What is a boolean in sql?
How to get each name only once from an employee table?
