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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Selecting from V$TIMER in a stored procedure

Re: Selecting from V$TIMER in a stored procedure

From: Veera Prasad <vprasad_at_olf.com>
Date: Mon, 30 Oct 2000 11:28:52 -0500
Message-Id: <10665.120575@fatcity.com>


A user with DBA pivilege cannot do a select on dynamic performance views within the stored procedures.

Grant select privilege on V$ view to the directly in order to work with v$ views in stored procs and do not grant any privileges on V$ views via Role.

Grant select on V_$timer to <user_name>;

Veera

Steven Monaghan wrote:

> I need to select from the V$TIMER table in a stored proc. Whenever I do, I
> get this error "PLS-00201: identifier 'SYS.V_$TIMER' must be declared". How
> can I do this select? The user creating the procedure has DBA privileges,
> so I don't think that is a problem... I also tried using the dbms_sql
> package to execute the query and it still fails. Any ideas, or is this
> impossible?
>
> TIA,
> Steve
> -------------------------------------
> Steven Monaghan
> Oracle DBA
> MSC Industrial Direct Co., Inc.
> Melville, NY
> MonaghaS_at_mscdirect.com
> http://www.mscdirect.com
> -------------------------------------
>
> This e-mail is intended for the use of the addressee(s) only and may contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law. If you are not the intended recipient, please do not
> read, copy, use or disclose the contents of this communication to others.
> Please notify the sender that you have received this e-mail in error by
> replying to the e-mail. Please then delete the e-mail and destroy any
> copies of it. Thank you.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steven Monaghan
> INET: MonaghaS_at_mscdirect.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Oct 30 2000 - 10:28:52 CST

Original text of this message

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