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

define data blocks ? : Sql dba

930

---

what is the difference between a web-garden and a web-farm? : Sql dba

1010

---

List the various privileges that a user can grant to another user?

988

---

What is cursor in pl sql?

1050

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1039

---

What is the difference between nvl function, ifnull function, and isnull function?

1050

---

What is sql resultset?

932

---

what are all the different types of indexes? : Sql dba

996

---

How to know the last executed procedure?

1032

---

what is a tablespace? : Sql dba

1004

---

Can a commit statement be executed as part of a trigger?

996

---

What is time based sql injection?

901

---

Is sql difficult?

1105

---

What is rank dense_rank and partition in sql?

972

---

What is the difference between database trigger and stored procedure?

1007

---