Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need V$ Table from PL/SQL

Re: Need V$ Table from PL/SQL

From: Nathan D. Hughes <nhughes_at_well.com>
Date: 1997/09/20
Message-ID: <6010op$old$1@was.hooked.net>#1/1

> I'm having a problem accessing Oracle v$ dynamic performance tables from
> inside PL/SQL (starting with v$parameter, but I also need others).

Make sure your compiling user is explicitly granted select on v_$parameter, and use that instead of v$parameter.

--

---
Nathan D. Hughes <nhughes_at_well.com>
Computer Consultants of America, Inc.
Received on Sat Sep 20 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US