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

Is truncate ddl or dml?

989

---

What is data definition language?

1088

---

What is lookup table in sql?

1037

---

How does a covering index work?

953

---

Do prepared statements prevent sql injection?

947

---

Why use subqueries instead of joins?

1078

---

How do I run sql profiler?

1059

---

What is a behavioral trigger?

970

---

What is autocommit sql?

981

---

What is bind reference and how can it be created?

1013

---

what happens if you no create privilege in a database? : Sql dba

999

---

How run sql*plus commands that are stored in a local file?

1054

---

What are system versioned tables?

1020

---

What are string functions in sql?

1234

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1127

---