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

Can we write dml inside a function in sql server?

1004

---

What is a primary key sql?

1093

---

give the syntax of grant and revoke commands? : Sql dba

1219

---

What are variables in pl sql?

1235

---

What are the types of functions in sql?

1068

---

What is difference between cursor and trigger?

1129

---

How do you add a column to a table?

1105

---

explain the delete statements in sql

1137

---

What is delete command in sql?

1174

---

What are functions in sql?

998

---

What trigger means?

1036

---

What port does sql server use?

1112

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1136

---

How does sql developer connect to oracle database?

1051

---

What is sql and how does it work?

1252

---