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

Show the cursor attributes of pl/sql.

992

---

What is database sql?

975

---

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..

2447

---

What are the various restrictions imposed on view in terms of dml?

906

---

Can we enter data in a table in design view?

910

---

What is the use of sqldataadapter?

906

---

How we can update the view?

1004

---

What is a full join sql?

980

---

what is the difference between sql and t-sql? : Transact sql

1040

---

What are different types of indexes?

957

---

How do I run a sql trace?

903

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1285

---

What is the purpose of normalization?

995

---

Can we join tables without foreign key?

907

---

Is drop table faster than truncate?

936

---