RE: Selecting from V$TIMER in a stored procedure

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Mon, 30 Oct 2000 11:16:56 -0500
Message-Id: <10665.120574@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0428C.D2A839CE
Content-Type: text/plain;

charset="iso-8859-1"

Steve, in order for your proc to compile the user must have select privilege on v$timer granted directly to them, not through a role. Sign in as sys, grant select on that view to the user, and try to recompile. It should work.

HTH Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

-----Original Message-----
From: Steven Monaghan [mailto:MonaghaS_at_mscdirect.com] Sent: Monday, October 30, 2000 10:31 AM
To: Multiple recipients of list ORACLE-L Subject: Selecting from V$TIMER in a stored procedure

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).

------_=_NextPart_001_01C0428C.D2A839CE
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Selecting from V$TIMER in a stored procedure</TITLE>
</HEAD>
<BODY>

Steve, in order for your proc to compile the user = must have select privilege on v$timer granted directly to them, not = through a role.  Sign in as sys, grant select on that view to the = user, and try to recompile.  It should work.

HTH

<P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>Qode.com</FONT>
<BR><FONT SIZE=3D2>4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>Suite G104</FONT>
<BR><FONT SIZE=3D2>Fort Lauderdale, FL&nbsp; 33319</FONT>
</P>

<P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>

C: 954.658.5849 <A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."

-----Original Message----- From: Steven Monaghan [<A = HREF=3D"mailto:MonaghaS_at_mscdirect.com">mailto:MonaghaS_at_mscdirect.com</A>= ]

<BR><FONT SIZE=3D2>Sent: Monday, October 30, 2000 10:31 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Selecting from V$TIMER in a stored =

procedure

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?

<P><FONT SIZE=3D2>TIA,</FONT>
<BR><FONT SIZE=3D2>Steve </FONT>
<BR><FONT SIZE=3D2>-------------------------------------</FONT>
<BR><FONT SIZE=3D2>Steven Monaghan</FONT>
<BR><FONT SIZE=3D2>Oracle DBA</FONT>
<BR><FONT SIZE=3D2>MSC Industrial Direct Co., Inc.</FONT>
<BR><FONT SIZE=3D2>Melville, NY</FONT>
<BR><FONT SIZE=3D2>MonaghaS_at_mscdirect.com</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://www.mscdirect.com" =

TARGET=3D"_blank">http://www.mscdirect.com</A>

<BR><FONT SIZE=3D2>-------------------------------------</FONT>

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

<BR><FONT SIZE=3D2>copies of it.&nbsp; Thank you.</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Steven Monaghan</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: MonaghaS_at_mscdirect.com</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
 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 = Received on Mon Oct 30 2000 - 10:16:56 CST