Re: reading unix host variables within PL/SQL

From: Brian P. Mac Lean <brian.maclean_at_teldta.com>
Date: 1997/06/16
Message-ID: <33A5A99D.756@teldta.com>#1/1

rob joss wrote:
>
> I have not been able to find a way of reading unix host variables from
> either SQLPLUS or within PL/SQL.
>
> Does anyone how to do this?
>
> Thanks

[oracle]: cat /tmp/var.sql
set verify off
prompt
prompt Variable1 -> &1
prompt Variable2 -> &2
prompt
select '&1' Variable1, '&2' Variable2 from dual; exit;
[pythia:oracle]: sqlplus -s / @/tmp/var.sql FIRST_VARIABLE SECOND_VARIABLE Variable1 -> FIRST_VARIABLE
Variable2 -> SECOND_VARIABLE

VARIABLE1 VARIABLE2
-------------- ---------------
FIRST_VARIABLE SECOND_VARIABLE [oracle]:

mailto:brian.maclean_at_teldta.com Received on Mon Jun 16 1997 - 00:00:00 CDT