Problem getting shell variable under NT

From: Romain SUAU <romain.suau_at_axa.com>
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

Original text of this message