Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: get unix environment variable within PL/SQL in a a varchar2 type.
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;
--
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 Wed Oct 27 1999 - 10:06:37 CDT