Hi Rakesh,
The Oracle user you are logged in as does not have select permission on
V$SESSION. Log in as sys and issue the command:
grant select on SYS.V_$SESSION to <oracle user name>;
HTH,
-Rocky
- Rakesh Dinger <rdinger_at_tritonconsultants.com> wrote:
> Hi, I a newbie in Oracle and am trying to create a package body in
> PL/SQL, so please bear with me.
>
> The statements are:
> SQL> create or replace package body RA_GET_TX_INFO_
> 2 as
> 3 begin
> 4 select SID from V$SESSION;
> 5 end RA_GET_TX_INFO_;
> /
> Warning: Package Body created with compilation errors.
> SQL> show errors package body RA_GET_TX_INFO_;
> Errors for PACKAGE BODY RA_GET_TX_INFO_:
>
> LINE/COL ERROR
> --------
> -----------------------------------------------------------------
> 3/10 PL/SQL: SQL Statement ignored
> 3/26 PLS-00201: identifier 'SYS.V_$SESSION' must be declared
>
>
> How can I select from V_$SESSION inside the body? The user account has
> dba role granted and I can select from V_$SESSION from a normal PL/SQL
> session.
>
> Any help greatly appreciated.
>
> Thanks
> Rakesh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rakesh Dinger
> INET: rdinger_at_tritonconsultants.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).
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rocky Welch
INET: rockyw_99_at_yahoo.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 Thu Mar 01 2001 - 14:54:51 CST