v$parameter

Just a quickie....

why is it that the following in SQL*Plus is fine..

select value
from v$parameter
where name = 'utl_file_dir';

whereas the following procedure produces the following error...

create or replace procedure test_v$param as

l_value varchar2(250);

begin

select value into l_value
from v$parameter
where name = 'utl_file_dir';

end;
/

LINE/COL ERROR

-------- -----------------------------------------------------------------
4/1      PL/SQL: SQL Statement ignored
5/6      PLS-00201: identifier 'SYS.V_$PARAMETER' must be declared

both are created by the same user.

cheers in advance. Received on Thu Dec 17 1998 - 10:36:04 CST