v$databse

From: Guido vd Zweerde <G.R.vandeZweerde_at_civ.utwente.nl>
Date: 1997/03/26
Message-ID: <3338FE9A.6DD5@civ.utwente.nl>#1/1

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 Received on Wed Mar 26 1997 - 00:00:00 CST