Re: get unix environment variable within PL/SQL in a a varchar2 type.

What operating system does this operate under? If Unix then environment variables have strict inheritence rules that follow the process hierachy and so must be set in the process that starts the database. In this case the process that does start the database could write ALL the environment variables to a table where they can be read.

This is different under NT which is not so strictly structured.

I hope this helps.

JJ

Marc Weinsock <MWeinstock_at_lds.com> wrote in message news: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.com
>
>
Received on Mon Nov 01 1999 - 23:00:18 CET