Answer Posted / prativa mishra

Yes, this package will execute.
example:- suppose we have create a package inside any user
create or replace package sn_pck is
procedure sn_pr(c out number);
end;

create or replace package body scn_pck is
procedure sn_pr(c out number) is
begin
select b into c from sn where name='sony';
DBMS_OUTPUT.PUT_LINE(C);
END;
END;

after that you shd connect hr user
and execute that package it execute 100%

how u will execute on hr user:-

declare
e number;
begin
prativa.sn_pck(e);
end;

note:- here i hv created that package in a user named prativa
and in user i hv create a table sn

What is the use of sqlerrd 3?

993

---

Is pl sql a scripting language?

1082

---

what is 'trigger' in sql? : Sql dba

1146

---

how to calculate the difference between two dates? : Sql dba

1115

---

What is an inner join sql?

1099

---

What are the most important ddl statements in sql?

1188

---

What is composite data type in pl sql?

1170

---

What found sql?

995

---

What is cost in sql execution plan?

1045

---

Do we need to create index on primary key?

966

---

explain what is mysql? : Sql dba

1132

---

Can we create index on primary key?

1019

---

Can you have a foreign key without a primary key?

1000

---

How many sql core licenses do I need?

995

---

How do I create a sql database?

1055

---