Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error ORA 00942 table or view does not exist for gv$session s,v$sql

VaibhavNov 9 2011 — edited Nov 9 2011
Hi,

I used following query in package it gives error ORA 00942 table or view does not exist but same query i run in plsql developer sql command it run successfully.

SELECT sid, serial#
into V_SID,V_SERIAL
FROM gv$session s,v$sql v
WHERE username = 'USER1'
and s.SQL_ID=v.SQL_ID


regards,
Vaibhav
This post has been answered by Pierre Forstmann on Nov 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2011
Added on Nov 9 2011
#general-database-discussions
5 comments
3,439 views