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 oracle and pl sql?

1106

---

Explain the difference between 'between' & 'and' operators in sql

981

---

How do I view a sql database?

1007

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2484

---

who introduced sql?

999

---

What is the purpose of the primary key?

1050

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

1008

---

Is it possible to pass parameters to triggers?

1084

---

How to select all records from the table?

1117

---

What is sql indexing?

1000

---

How do I enable sql encryption?

1006

---

Explain alias in sql?

1027

---

What are sql indexes?

979

---

what is the command line end user interface - mysql? : Sql dba

967

---

What is sql integrity?

1134

---