Problem getting shell variable under NT
Date: 2000/04/26
Message-ID: <3906B86C.9B00E3E3_at_axa.com>#1/1
Hello,
[Quoted] [Quoted] I'm trying to get back values set into shell scripts under sql command
files launched by these scripts.
For example, in a
test.cmd
#####################################
REM This is the command file
SET USER=username
SET PASS=password
SET REP=C:\TEST
svrmgr23.exe < c:\start.sql
#####################################
start.sql
#####################################
# This is the sql file
CONNECT %user%/%PASS%
STARTUP PFILE=%REP%\init.ora
EXIT
#####################################
This method does not work at all... I used to develop scripts under Unix where I could use ${...} for calling back shell variable values. I use Oracle under NT now and don't know how to do this...
If you can send a copy of your response to rsuau_at_free.fr I would appreciate it a lot.
Thanks for any help,
Romain
Received on Wed Apr 26 2000 - 00:00:00 CEST