| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Newbie question on Packages
yup :)
>From: "Mohan, Ross" <MohanR_at_STARS-SMI.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Newbie question on Packages
>Date: Thu, 01 Mar 2001 12:40:41 -0800
>
>Beat me with an overextended RBS if
>you need be, but other than any
>permission issue, don't you need
>to SELECT....INTO... in PL/SQL?
>
>Ready for my beating,
>
>- Ross
>
>-----Original Message-----
>Sent: Thursday, March 01, 2001 3:27 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.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 - 16:08:36 CST
 |
 |