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
- 6976 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
Explain spool.
What is bitemporal narrowing?
What is dml and ddl?
how to check myisam tables for errors? : Sql dba
What are stored procedures used for?
How to disable a trigger name update_salary?
What is sqlerrm?
What is compute?
Does sqlite need a server?
Is ms sql is free?
What is nested table in pl sql?
how can we submit a form without a submit button? : Sql dba
explain commit and rollback in mysql : sql dba
How do you delete data from a table?
What is mdf ldf and ndf?
