Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: v$databse
Hi ,
All the data dictionary tables (static and dynamic) are owned
by super user 'SYS'.
-- AMARENDRA B NETTEM ORACLE CONSULTANT WHITTMAN-HART INC., CHICAGO (http://www.iit.edu/~nettama) Guido vd Zweerde <G.R.vandeZweerde_at_civ.utwente.nl> wrote in article <3338FE9A.6DD5_at_civ.utwente.nl>...Received on Thu Mar 27 1997 - 00:00:00 CST
> Hi,
>
> consider the next problem:
>
> connected as system
> select name from v$database;
> --> returns SID-name
>
> when in the next procedure :
> create or replace procedure t
> is
> x char(8);
> begin
> select name
> into x
> from v$database;
> end;
> /
>
> I get the next error:
> LINE/COL ERROR
> -----------------------------------------------------------------
> 5/3 PL/SQL: SQL Statement ignored
> 7/8 PLS-00201: identifier 'SYS.V_$DATABASE' must be declared
>
> What is the problem? If I create the procedure as 'SYS' it works, but
> that is not what I want.
>
> Thanx,
> Guido vd Zweerde
> University of Twente
> The Netherlands
> G.R.vandeZweerde_at_civ.utwente.nl
>