we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?
- 3 Answers
- 7872 Views
- TCS, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is anonymous block in sql?
What is the difference between local variables and global variables?
What is a .db file?
which operator is used in query for pattern matching? : Sql dba
How much does a sql dba make? : SQL DBA
how to fetch common records from two tables? : Sql dba
What is the difference between alter trigger and drop trigger statements?
What is Materialized View? In What Scenario we Use Materialized View?
what are ddl statements in mysql? : Sql dba
What is an emotional trigger?
how to use like conditions? : Sql dba
what is msql? : Sql dba
Why do we use cursors?
How can you load microsoft excel data into oracle? : aql loader
Why use stored procedures?
