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

What is number function in sql?

980

---

What is use of package in pl sql?

1017

---

how to increment dates by 1 in mysql? : Sql dba

978

---

How does an execution block start and end in pl sql?

955

---

When is the explicit cursor used ?

1038

---

What is sqlcontext?

1087

---

What is pl/sql table? Why it is used?

1038

---

What is sqlerrm?

941

---

What is the maximum number of rows in sql table?

1030

---

Is pl sql and postgresql same?

1138

---

Difference between global and parameter variables?

1970

---

What is mdf ldf and ndf?

1002

---

What are sql built in functions?

939

---

What are the two parts of design view?

1020

---

What does pl sql developer do?

935

---