can use the following like overloading concept in a single
package:

procedure p1(a varchar),
procedure p1(a varchar2),
procedure p1(a char)

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

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does rowid help in running a query faster?

942


What is meant by user defined function?

560


what is cross join? : Sql dba

546


What are all the common sql functions?

535


How do I view tables in mysql?

516






What are %type and %rowtype for?

588


how to check myisam tables for errors? : Sql dba

557


What does the argument [or replace] do?

551


What is a join?

594


what is timestamp in mysql? : Sql dba

541


Do we need to rebuild index after truncate?

505


Define sql delete statement.

534


In a distributed database system, can we execute two queries simultaneously?

544


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

468


What do you understand by pl/sql packages?

552