Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> get unix environment variable within PL/SQL in a a varchar2 type.

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

From: Dhiraj Verma <dhiraj.verma_at_fmr.com>
Date: Tue, 26 Oct 1999 11:57:30 -0500
Message-ID: <3815DD79.8E3C5C72@fmr.com> 





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;





Received on Tue Oct 26 1999 - 11:57:30 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US