Re: Session variable?

From: <G.Plivna_at_itsystems.lv>
Date: Thu, 19 Oct 2000 12:06:44 +0300
Message-Id: <10654.119753@fatcity.com>

You can create package specification with public varibles in it

something like
CREATE OR REPLACE PACKAGE my_pkg AS
var1 VARCHAR2(100);
var2 NUMBER;
END;
/

and access these variables with my_pkg.var1 and my_pkg.var2

Gints Plivna

                                                                                                                   
                    "Andor Gyula"                                                                                  
                    <gy.andor_at_eur        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    omacc.hu>            cc:                                                                       
                    Sent by:             Subject:     Session variable?                                            
                    root_at_fatcity.                                                                                  
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    00.10.19                                                                                       
                    12:10                                                                                          
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L                                                                                       
                                                                                                                   
                                                                                                                   

Hi !

Is there any way to create user-defined session variables in Oracle?

Thanks in advance.

Gyula Andor
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Andor Gyula
  INET: gy.andor_at_euromacc.hu

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 Oct 19 2000 - 04:06:44 CDT