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

Enlist the data types that can be used in pl/sql?

1069

---

How many types of triggers are there in pl sql?

1066

---

What is aggregate function in sql?

1035

---

What is a rank in sql?

963

---

What are the built in functions of sql?

1030

---

What is data control language?

986

---

How can the performance of a trigger be improved?

1045

---

Which is better stored procedure or query?

957

---

What are predefined functions in sql?

1042

---

Can we call procedure in select statement?

1053

---

What is the size of partition table?

1046

---

What is sql prepared statement?

981

---

Can we enter data in a table in design view?

967

---

Is sql developer case sensitive?

994

---

How to call a javascript function from pl sql?

1138

---