| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
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. Received on Mon Oct 30 2000 - 09:30:24 CST
 |
 |