Re: Access V$ Tables from stored procedure
From: Michael Serbanescu <ms_at_cmprime.cis.att.com>
Date: 1996/10/03
Message-ID: <3253BB5A.742A_at_cmprime.cis.att.com>#1/1
> In article <323D560A.3129_at_comdisco.com>, Roderick Prince <rrprince_at_comdisco.com> wrote:
> |> Attempting to define access the V$ dynamic tables like V$_SESSION table
> |> from within a stored procedure leads an error when I attempt to store
> |> the procedure. The error returned is PLS_00201:
> |> identifier 'SYS.V$_SESSION' must be declared.
> |>
> |> The error message and resolution notes led me to modify the sql
> |> statement to referenct V$Session, V$_SESSION, SYS.V$Session, and
> |> SYS.V$_SESSION. Same message is generated.
> |>
> |> Any ideas on how I can access these tables?
>
Date: 1996/10/03
Message-ID: <3253BB5A.742A_at_cmprime.cis.att.com>#1/1
Run the ?/rdbms/admin/utlmontr.sql script, which grants public access to all the views used by the character-mode SQLDBA.
I hope this helps.
Michael Serbanescu
Sr. ORACLE DBA, TRECOM Business Systems, Edison, NJ
ms_at_cmprime.cis.att.com
(908)576-3894
> In article <323D560A.3129_at_comdisco.com>, Roderick Prince <rrprince_at_comdisco.com> wrote:
> |> Attempting to define access the V$ dynamic tables like V$_SESSION table
> |> from within a stored procedure leads an error when I attempt to store
> |> the procedure. The error returned is PLS_00201:
> |> identifier 'SYS.V$_SESSION' must be declared.
> |>
> |> The error message and resolution notes led me to modify the sql
> |> statement to referenct V$Session, V$_SESSION, SYS.V$Session, and
> |> SYS.V$_SESSION. Same message is generated.
> |>
> |> Any ideas on how I can access these tables?
>
>
> |>
> |> Thanks,
> |> Roderick...
Received on Thu Oct 03 1996 - 00:00:00 CEST