From rdinger@tritonconsultants.com Thu, 01 Mar 2001 12:41:59 -0800 From: Rakesh Dinger Date: Thu, 01 Mar 2001 12:41:59 -0800 Subject: Newbie question on Packages Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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).