problem while using v$parameter in a package
622094Jan 20 2009 — edited Jan 20 2009Hi.
I have to get some data from the v$parameter view inside a package but when I compile it, it throws me the error "PL/SQL: ORA-00942: table or view does not exist". However, the schema owner of the pacckage has privileges over that view because when I execute select * from v$parameter outside of the package, I get data without problems.
I've tried to compile using the names SYS.v$parameter and SYS.v$_parameter, but none of these works.
Do I need special privileges from sys or something like that? What is the command?
I also tried this:
create or replace view oracle_parameter
as
select *
from v$parameter;
but it showed me the error "Insuficient privileges"
Thanks.