Re: get unix environment variable within PL/SQL in a a varchar2 type.
From: Marc Weinsock <MWeinstock_at_lds.com>
Date: Wed, 27 Oct 1999 15:06:37 GMT
Message-ID: <38171441.E4E2D4EC_at_lds.com>
Date: Wed, 27 Oct 1999 15:06:37 GMT
Message-ID: <38171441.E4E2D4EC_at_lds.com>
I do believe if U are using Oracle 8 their is a OS utilitly package that will do this for U. I do not have an Oracle 8 machine available to help U out. If U are using oracle 8 check out all their stores packages.
Dhiraj Verma wrote:
> Hi ,
> I need to read the value of the environment variable from within a
> PL/SQL code and then store it in the a varchar2 datatype
> How can I achive ?
> e.g
> declare
> v_name varvar2(200);
> begin
> v_name := <GET HERE VALUE OF SAY $MYDTATADIR>
> end;
-- =============================================== Marc Weinstock Logical design Solutions 55 Broadway - 21st Floor New York, New York 10006 Phone: 800.221.5327 x2136 Fax: 212-825-2245 E-Mail: MWeinstock_at_lds.com Web: http://www.lds.comReceived on Wed Oct 27 1999 - 17:06:37 CEST