RE : Selecting from V$TIMER in a stored procedure

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Mon, 30 Oct 2000 16:44:00 +0100
Message-Id: <10665.120573@fatcity.com>

Steven,

You have hit this old favourite 'you cannot refer to something in a stored procedure if you have not been directly granted access to it, as opposed to through a role'. Connect as internal,

GRANT SELECT ON V_$TIMER TO the appropriate user (WITH GRANT OPTION would make sense)
and shazam! it should work.

-- 
Regards,

  Stephane Faroult
  email: sfaroult_at_oriolecorp.com 
  Oriole Corporation
  Voice:  +44  (0) 7050-696-269 
  Fax:    +44  (0) 7050-696-449 
  Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------


> 

> 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

> -------------------------------------

Received on Mon Oct 30 2000 - 09:44:00 CST