Accessing V$ Tables

From: Srinivasan Sankar <srinisankar_at_nospam.com>
Date: 1997/10/21
Message-ID: <344CB089.7A027776@nospam.com>#1/1

I'm trying to access some V$ tables thro' a stored procedure. But its giving me the following errors.

4/2      PL/SQL: SQL Statement ignored
6/7      PLS-00201: identifier 'SYS.V_$SQLAREA' must be declared

This is what I'm doing in a procedure,

create or replace procedure test
as
begin

        insert into testable(sqltext)
        select sqltext
        from v$sqlarea;

end;

But when i run this query as a pl/sql block like this,

begin

        insert into testable(sqltext)
        select sqltext
        from v$sqlarea;

end;

it works. Is it not possible to access these table thro' a procedure or a function?

Thanks.......Srini

-- 


*****************************************************************

"There are no strangers in life, only friends you've not yet met"
Srinivasan Sankar                         srinisankar_at_hotmail.com


*****************************************************************

P.S:- Replace "nospam" with "hotmail" while replying to me

Received on Tue Oct 21 1997 - 00:00:00 CDT